Our installation of HelpmeICT contains about 14 sites and 1350 users. (These users can work on all 14 sites so the usersites table contains about 19000 records). We have about 20000 issues.
The "Find Issue" page took about 8 seconds to display which frustrated the support engineers. We have optimized the queries so that it takes about 1,5 seconds now to display the page.
Maybe others can...
2008-12-17 10:45:06 UTC in helpmeict