#63 Performance issue (solved and question)
First, thanks for this great software!
We have installed it in our testing environment to
replace our current helpdesk system (Support Magic).
We have 11 sites, and about 700 users. We noticed that
after we added all the users, the issue details took
about 60 seconds to appear! (the 'find issue' was fast,
but after clicking on an issue it took a long time).
We solved this by optimizing the SQL query in issues.php:
Whe changed line 808 from:
SELECT DISTINCT id,name FROM vw_UserTypes WHERE
(active=1 AND vw_Users.available=1 AND
usertypesortorder IN (2,3,4) AND id>0 AND site=3) OR
id=1495 OR-DER BY name;
to
SELECT DISTINCT vw_UserTypes.id,vw_UserTypes.name FROM
vw_Users LEFT JOIN vw_UserTypes ON
(vw_Users.id=vw_UserTypes.id) WHERE
(vw_UserTypes.active=1 AND vw_Users.available=1 AND
usertypesortorder IN (2,3,4) AND vw_UserTypes.id>0 AND
site=3) OR vw_UserTypes.id=1495 ORDER BY vw_UserTypes.name;
Now the page appears in less than a second!
=====================================
The problem we still have is that te page "Sites and
Users" is to slow. After about 30 seconds we get an
error in Firefox:
"A script on this page is causing Mozilla to run
slowly. If it continues to run, your computer may
become unresponsive. Do you want to abort the script?"
This is probably caused bij the 700 (to many??) users,
that can be assigned to 11 sites. Proc-essing this in
javascript is to time consuming. Does anyone have the
same problem and did a redesign of this page?
Regards,
P. Diender
G.J. Werler
Logged In: YES
user_id=1233074
Rather than using javascript, perhpas this would be better
using a number of frames (at last, a justification for frames!)