[Koha-devel] Slow Searching

[Marcel de Rooy]

Barry,
The zebrasrv(1) [warn] ir_session (exception) is unrelated to your performance issues.
The yaz-client search cannot be compared with the interface. 
Koha 3.22.06 is much slower than say Koha 3.16.
You really need plack and memcached. Check if they function properly.
16GB RAM and SSD sounds good to me.

 Marcel

-----Oorspronkelijk bericht-----
Van: koha-devel-bounces at lists.koha-community.org [mailto:koha-devel-bounces at lists.koha-community.org] Namens Barry Cannon
Verzonden: maandag 23 mei 2016 12:36
Aan: , <koha-devel at lists.koha-community.org>
Onderwerp: [Koha-devel] Slow Searching

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/