[Koha-devel] 3.18 search speed

[Paul A]

I wrote a few days ago that 3.18.2 appeared slow vis-à-vis our production 
3.8.5:

3.8.5                      3.18.2
=================================
Time to search catalogue for 's' 
<http://opac.navalmarinearchive.com/cgi-bin/koha/opac-search.pl?idx=&q=s>
<2 secs                    19 secs    LAN

It was suggested that I use the package rather than the tarball, and that I 
use NYTProf for analysis rather than ncap.

I have done so and have "Profile of 
/usr/share/koha/opac/cgi-bin/opac/opac-search.pl for 21.3s (of 21.3s), 
executing 248515 subroutine calls in 592 source files and 58 string evals."

The very obvious "slow" element (19.7 secs of a total of 21.3 secs) is:

# spent 19.7s within Net::Z3950::ZOOM::resultset_record which was called 27 
times, avg 728ms/call: # 27 times (19.7s+0s) by ZOOM::ResultSet::record at 
<file://///Hood/homes/paul/nytprof/ZOOM-pm-65-line.html#739>line 739 of 
ZOOM.pm, avg 728ms/call
sub Net::Z3950::ZOOM::resultset_record; # xsub

as a comparison, a mirror image of our production 3.8.5 on a *very* old box 
(same mysql db and same Net::Z3950::ZOOM version 1.26):

# spent 73.2ms within Net::Z3950::ZOOM::resultset_record which was called 
120 times, avg 610µs/call: # 120 times (73.2ms+0s) by 
ZOOM::ResultSet::record at 
<file://///Hardy/homes/paul/nytprof2/ZOOM-pm-62-line.html#739>line 739 of 
ZOOM.pm, avg 610µs/call
sub Net::Z3950::ZOOM::resultset_record; # xsub

Thoughts anyone? I can obviously supply more info from NYTProf as required 
e.g. both boxes reported 12 calls to Net::Z3950::ZOOM::event, with Koha 
3.18 taking 237ms whereas the *very* old box needed 338ms (that's well 
below the difference I would expect from the hardware.)

Note also that 3.8 only needed 168568 subroutine calls in 313 source files 
and 37 string evals.
compared to 248515, 592 and 58 for 3.18 for the exact same search. The 
results are identical -- perhaps minor variances in the "relevance" ordering.

Best -- Paul

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20150109/e8e97e8d/attachment.html>