[Koha-bugs] [Bug 2084] Warn staff about resource hogging scripts

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2084





------- Comment #8 from Andrew.moore at liblime.com  2008-08-06 10:44 -------
I added over 60,000 patrons with randomish names starting with 'a' into my test
database, but couldn't reproduce any kind of slowness or high system load when
making Koha recommend completions in the circulation search. So, I'm not sure
how to patch ysearch.pl to fix any problem here.

If we see problems with this again, perhaps looking into one of these options
may help:

* have ysearch.pl return only 10 results. I think only 10 are shown to the user
anyway, so returning more may be unnecessary.
* check the indexes on the patron tables. There does not appear to be indexes
on the firstname or surname fields.
* do no autocompletion until more than one character is typed into the field,
maybe 3 or so. This can cut down on the number of matching names searched.

Since I don't know where the problem is, I can't recommend one of those or
another fix. I'm moving on for now.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.