[Koha] Slow OPAC search

[Jonathan Druart]

Hello Manoj,

Koha 3.22.02 is a lot of versions behind the last 3.22.x version (3.22.21).

Take a look at the value of use_zebra_facets in your koha-conf.xml file.
If enabled, disable it (see bug 13665).

If you are not using Plack, take a look at this wiki page
https://wiki.koha-community.org/wiki/Benchmark_for_16.11
You will see the performance you will gain to use it (and memcached) on
Koha versions >= 16.05

Regards,
Jonathan

On Thu, 3 Aug 2017 at 08:04 Manoj Kummini <mkummini at cmi.ac.in> wrote:

> Hello everyone,
>
> I am new on this list, and have just begun, with a colleague, managing the
> KOHA installation in our library that has about 10000 books and some
> journals.
>
> Our OPAC had become terribly slow and on exploring we noticed that a
> mysqldump would result in a file of over 5GB. This large size, we realized,
> was due to the cleanup_database.pl script not being called. After running
> it for about a week with
>
>     --sessdays 7 --zebraqueue --list-invites --mail --merged --import
> --logs --searchhistory --restrictions
>
> we have brought the mysqldump file to about 20-22 MB.
>
> While the speed of an OPAC search has improved considerably, it is still
> slow. For example, as suggested by a reply to a similar question, I looked
> at "Inspect Element > Network" and found that most queries of GET
> opac-detail.pl and opac-search.pl take about 9-10 seconds.
>
> Koha Version: 3.2202000
>  (<meta name="generator" content="Koha 3.2202000" />)
> running on a virtual machine (Debian 8.3). The base machine is Debian 9.0.
> MySQL server 5.5.47-0+deb8u1 is on the VM itself.
>
> Uses zebra.
>
> On the virtual machine
> # free -m
> gives
>              total       used       free     shared    buffers     cached
> Mem:         16023       2042      13981        341        174       1290
> -/+ buffers/cache:        576      15446
> Swap:        16383          0      16383
>
> We plan to upgrade to Koha 17.05 soon, but wanted to understand how to
> speed up the search. Is moving to a stand-alone server the only solution?
>
> I am new to this, so I might not have given you all the relevant
> information about the problem. Please let me know if some other piece of
> information will help.
>
> Thank you.
>
> With regards,
> Manoj.
>
> --
> Manoj Kummini
> Associate Professor, Mathematics, Chennai Mathematical Institute,
> Siruseri Tamilnadu 603103. India. 12 deg 50 min N, 80 deg 13 min E.
> http://www.cmi.ac.in/~mkummini/index.html
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>