http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2084 ------- Comment #8 from Andrew.moore@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.