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 <mkumm...@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@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
