<html>
<body>
I wrote a few days ago that 3.18.2 appeared slow vis-à-vis our production
3.8.5:<br><br>
3.8.5
3.18.2<br>
=================================<br>
Time to search catalogue for 's'
<<a href="http://opac.navalmarinearchive.com/cgi-bin/koha/opac-search.pl?idx=&q=s" eudora="autourl">http://opac.navalmarinearchive.com/cgi-bin/koha/opac-search.pl?idx=&q=s</a>><br>
<2
secs
19 secs LAN<br><br>
It was suggested that I use the package rather than the tarball, and that
I use NYTProf for analysis rather than ncap. <br><br>
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."<br><br>
The very obvious "slow" element (19.7 secs of a total of 21.3
secs) is:<br><br>
# 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
<a href="file://///Hood/homes/paul/nytprof/ZOOM-pm-65-line.html#739">line
739 of ZOOM.pm</a>, avg 728ms/call<br>
sub Net::Z3950::ZOOM::resultset_record; # xsub <br><br>
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):<br><br>
# 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
<a href="file://///Hardy/homes/paul/nytprof2/ZOOM-pm-62-line.html#739">line
739 of ZOOM.pm</a>, avg 610µs/call<br>
sub Net::Z3950::ZOOM::resultset_record; # xsub<br><br>
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.)<br><br>
Note also that 3.8 only needed 168568 subroutine calls in 313 source
files and 37 string evals.<br>
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.<br><br>
Best -- Paul <br>
<x-sigsep><p></x-sigsep>
---<br>
Maritime heritage and history, preservation and conservation, <br>
research and education through the written word and the arts.<br>
<<a href="http://navalmarinearchive.com/" eudora="autourl">http://NavalMarineArchive.com</a>>
and
<<a href="http://ultramarine.ca/" eudora="autourl">http://UltraMarine.ca</a>><br>
</body>
</html>