2011/10/27 IBS Computer Support <ibssupport@colorado.edu>:
Hello Everyone,
New to the list, new to Koha, increasingly frustrated :}
I’ve built a koha server for our in-house library which seems to have gone over fine but I’m having issues with incredibly slow search response.
I’m running the latest stable koha-common 3.6 (updated a few minutes ago) on Debian 6.0.3.
I have successfully entered in a record for one book. When I search from the initial koha page it takes ~4 seconds to find this item. Then once the item has loaded if I click one of the links for a searchable item (author, details, etc.) it takes ~4-5 seconds for it to load. When I open all of these options at the same time in new tabs it takes forever. It seems to be an almost linear increase in the time it takes for the searches to complete. Also, each new tab running a different search will continue to run until one has finished, then once one has finished another will go. This process is ~4 seconds for each search. Seems like all searches are in a very slow queue.
So for this example book I have in the system there are 7 items that are searchable. If I go through and open each in a separate tab the total process for all of this is 30+seconds.
I tried running a webserver load test with just 10 users clicking on a different link each time the new page loaded and it failed horribly with an average page load wait of 50 seconds
Hmm definitely not seeing this behaviour here, I just did a search on a db for keyword a and got “kw,wrdl: a ” returned 47454 results. In 1.09s Is your server low on RAM, or are the zebra indexes on a slow partition or the like? Chris