[Koha] Introduction and incredibly slow searches

[Chris Cormack]

2011/10/27 IBS Computer Support <ibssupport at 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