[Koha] More on OPAC Search too slow in Koha 18.05.05

[Jonathan Druart]

Hola Camilo,

Take a look at the value of use_zebra_facets in your koha-conf.xml file.
If enabled, disable it (see bug 13665). You may also want to play with the
value of maxRecordsForFacets.

Saludos,
Jonathan

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13665


On Thu, 8 Nov 2018 at 19:35 Camilo Freire <camilofreire at gmail.com> wrote:

> With respect to my last post on problems in OPAC Search in Koha, I've found
> that the problem is in the method  _get_facets_from_zebra called from the
> method GetFacets of the class Search.pm. The asyncronous programming has
> nothing to do with the problem.
>
> Perhaps someone have had a similar problem or can help me about this.
>
> Thanks in advance
> Camilo Freire
>
>
>
> ---------- Forwarded message ---------
> From: Camilo Freire <camilofreire at gmail.com>
> Date: mié., 7 nov. 2018 a las 20:09
> Subject: OPAC Search too slow in Koha 18.05.05
> To: <koha at lists.katipo.co.nz>
>
>
> Good afternoon. My name is Camilo Freire, from Montevideo, Uruguay.
>
> I have a catalogue with around 280.000 bibliographic records in Koha
> 18.05.05. When I do some searches whose hit's number is about 14.000
> records the time of search climbs from an average of 2 seconds per search
> to 40 to 80 seconds around. I've a virtual machine with 6GB of RAM, with a
> virtual Xeon of 2GHz.
>
> Koha is making the OPAC search calling the function getRecords which is in
> the lib/C4/Search.pm file. As I've seen this function first makes a call to
> the ZOOM::search function and then makes an asynchronous loop for getting
> the records (don't do that in ZOOM::search?) and facets, calling the
> _ZOOM_event_function. The Zebra search in ZOOM::search is quite fast, and
> takes no more than 0.3 seconds to perform the search. It seems that the
> delay is in the asynchronous facets in the _ZOOM_event_loop function. Is
> not clear to me what exactly the _ZOOM_event_loop is doing, apart from
> retrieving the facets, which are not necessary for me.
>
> Can I resolve in some way this problem, getting rid of the _ZOOM_event_loop
> or installing other version? As a first step I've enabled plack, which is a
> great help in speeding up the application but not in this case.
>
> Thank you very much in advance.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>