[Koha-devel] Slow Searching

[Jonathan Druart]

Hi Barry,

Have a look at bug 15342 and all related.
Bug 16041 is in 3.22.7 and could help for search results.
Bug 15263 as well.

Regards,
Jonathan

2016-05-23 11:36 GMT+01:00 Barry Cannon <bar at interleaf.ie>:
> Hi,
>      I have noticed some slow opac/intranet searching on sites and I can't seem to pinpoint the problem. The "opac-search.pl", takes between 5500ms and 7500ms for any search term - the hit count can be 10 or 16000, the search time is comparable. Running the same search, directly via the yaz-client, returns the hit count (and record dump) almost instantly.
>
> The sites are plack enabled, running Koha 3.22.06 and memcache is also configured. The zebra-out.log shows lines similar to below (which appear to be innocuous):
>
> 15:38:02-16/05 zebrasrv(1) [warn] ir_session (exception)
> 15:47:14-16/05 zebrasrv(2) [warn] ir_session (exception)
> 15:57:15-16/05 zebrasrv(3) [warn] ir_session (exception)
> 16:03:22-16/05 zebrasrv(4) [warn] ir_session (exception)
> 16:04:15-16/05 zebrasrv(5) [warn] ir_session (exception)
>
> The only other log of interest is the opac-error.log but this just displays some equally innocuous errors.
>
> On one system there are just under 100k biblios. It is a relatively small system but just to be certain I spun up a test box and assigned it 16GB RAM and 8 CPUs, SSDs for storage. I left the sysprefs as vanilla. I noticed no difference in the response time(s). The majority of sites are running Jessie. I have netdata running on the boxes and there is never any load on any resource - no slow MySQL queries either.
>
> I also tested some of the demo Koha sites, from the community site, and while they're are not as slow, they certainly appear to be slow(ish).
>
> Would anyone have any ideas on what I might have overlooked? Could this just be a perception issue (although most of the clients have raised issues).
>
> Thanks
>
> Regards
> Barry Cannon
> Interleaf Technology
> http://www.interleaf.ie
> Tel: +35312865855
> Email: bc at interleaf.ie
> Skype: bar.cannon
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/