poor performance on issue view & search form

Thread: poor performance on issue view & search form

Search this list only Search all lists
poor performance on issue view & search form
United States	2007-03-28 16:13:07
We've seen performance with the roundup web interface degrade as our tracker has grown -- but it the strangest places. After turning on timing, here are typical values for "Time elapsed": - "Search" page (before the form is submitted) -- 17 seconds - View issueABCD of an issue with 3-4 messages -- 6 seconds - "User List" page -- 7 seconds - "Create New Issue" page (before submit) -- 5.6 seconds. - "Your Issues" with 47 issues showing -- .5 seconds - "Show All" (issues) 147 issues -- .5 seconds Any ideas what the bottleneck might be? watch --interval=.2 mysql -e "show processlist" doesn't indicate any specific query is taking a long time -- they just flash in and flash out. The DB connection is mostly idle. (The time measurements above are an average of 3 or 4 page loads without the mysql process watch running). Our setup: - Roundup 1.3.1 (via mod_python) - 5100 issues; 3000 of them were auto-generated by a rogue script and were retired - 12000 messages - 700 users - Apache/2.0.59, mod_python/3.2.10, Python/2.5 - RHEL 4u1 on dual 2.8ghz Xeon (32 bit) - MySQL 4.1.11 backend on the same box - The standard template with a few cosmetic customizations (make assignedto a pop-up containing members of a specific group; add a "low" priority; tweak the "Your Issues" page so that it meta- refreshes every 45 seconds) Other than that, we're very happy with Roundup. It's nice to have a simple tracker that we can customize so easily. Thanks for the help! - Max ------------------------------------------------------------ ------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default. php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Roundup-users mailing list Roundup-userslists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/roundup-u sers

Re: poor performance on issue view & search form
Australia	2007-03-28 16:46:14
On 29/03/2007, at 7:13 AM, Max Campos wrote: > We've seen performance with the roundup web interface degrade as our > tracker has grown -- but it the strangest places. After turning on > timing, here are typical values for "Time elapsed": > > - "Search" page (before the form is submitted) -- 17 seconds > - View issueABCD of an issue with 3-4 messages -- 6 seconds > - "Create New Issue" page (before submit) -- 5.6 seconds. What fields do you have here, and how are they represented (text entry or drop-down menus)? I suspect you might have user menu drop-downs in there, and that's known to be slow for lots of users. > - "User List" page -- 7 seconds This is, unfortunately for the moment, reasonable for 700 users. Richard ------------------------------------------------------------ ------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default. php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Roundup-users mailing list Roundup-userslists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/roundup-u sers

Re: poor performance on issue view & search form
	2007-03-28 21:15:27
>> We've seen performance with the roundup web interface degrade as our >> tracker has grown -- but it the strangest places. After turning on >> timing, here are typical values for "Time elapsed": >> >> - "Search" page (before the form is submitted) -- 17 seconds >> - View issueABCD of an issue with 3-4 messages -- 6 seconds >> - "Create New Issue" page (before submit) -- 5.6 seconds. > > What fields do you have here, and how are they represented (text > entry or drop-down menus)? > > I suspect you might have user menu drop-downs in there, and that's > known to be slow for lots of users. Hi Richard, Thanks, that's exactly what the problem was. I temporarily removed the 3 username pop-ups shown on the default search page and the load time went from 17 seconds down to about 1/2 second. On our issue view page we've replaced assigned to text box with a filtered username pop-up (see below) and I'm sure it's the same problem. <!-- this stuff handles when the user is logged in (i.e. show an assignedto selector) --> <span tal:condition="context/is_edit_ok"> <select name="assignedto"> <option value="-1">- no selection -</option> <tal:block tal:repeat="user db/user/list"> <option tal:condition="python:user.hasPermission('Fixer', context._classname)" tal:attributes="value user/id;selected python:user.id == context.assignedto" tal:content="user/username"></option> </tal:block> </select> </span> </td> Thanks again. - Max ------------------------------------------------------------ ------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default. php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Roundup-users mailing list Roundup-userslists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/roundup-u sers

Re: poor performance on issue view & search form
Sweden	2007-03-31 06:34:12
Max Campos <listsbpsw.biz> writes: >>> We've seen performance with the roundup web interface degrade as our >>> tracker has grown -- but it the strangest places. After turning on >>> timing, here are typical values for "Time elapsed": >>> >>> - "Search" page (before the form is submitted) -- 17 seconds >>> - View issueABCD of an issue with 3-4 messages -- 6 seconds >>> - "Create New Issue" page (before submit) -- 5.6 seconds. >> >> What fields do you have here, and how are they represented (text >> entry or drop-down menus)? >> >> I suspect you might have user menu drop-downs in there, and that's >> known to be slow for lots of users. > > Hi Richard, > Thanks, that's exactly what the problem was. I temporarily removed > the 3 username pop-ups shown on the default search page and the load > time went from 17 seconds down to about 1/2 second. On our issue > view page we've replaced assigned to text box with a filtered > username pop-up (see below) and I'm sure it's the same problem. Depending on your backend and your permissions setup, you might be able to get very good performance even on user select boxes. Check out http://svn .python.org/view/tracker/instances/python-dev/html/issue.ite m.html?rev=54388&view=markup and searc for 'sql' for an example we use for http://bugs.python.org. Rgds, EF -- Erik Forsberg http://efod.se GPG/PGP Key: 1024D/0BAC89D9 ------------------------------------------------------------ ------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default. php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Roundup-users mailing list Roundup-userslists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/roundup-u sers

[1-4]

about | contact Other archives ( Real Estate discussion Medical topics )