[Koha-devel] 3.18 search speed

[Christopher Davis]

Paul,

I don't know if someone else has already mentioned this, but does your institution utilize any catalog enhancements such as cover art images, series lists, or book reviews? I remember last year when Syndetics added twenty seconds to our OPAC searches until we disabled it. Try turning off any or all of these services and then re-measure the performance.

HTH,

Christopher Davis, MLS
Systems & Electronic Services Librarian
Uintah County Library
cgdavis at co.uintah.ut.us
(435) 789-6261
uintahlibrary.org
facebook.com/uintahcountylibrary


On January 3, 2015 6:17:33 PM MST, Paul A <paul.a at navalmarinearchive.com> wrote:
>I'm really looking for some help here, please, my brain (whatever is
>left!) 
>is swimming in Perl code.
>
>I'm getting the notion that maybe the db conversion (3.08 => 3.18,
>which 
>reported all done) missed something, or that after two years of use, 
>there's possibly something corrupt.  If not, there's maybe a "config
>file" 
>that's missing somewhere with some fine detail. All perl modules are 
>present (except 3.18 tells me that Readonly::XS (1.02) is not
>installed, 
>but I have 1.05), permissions have been verified, ps -u koha shows the 
>daemon and zebrasrv running, mysqlcheck is clean, etc.
>
>Wireshark/pcap gives (repeatable):
>http://koha-admin318/cgi-bin/koha/catalogue/search.pl?q=t   slow (~20
>secs) 
>and finds all results absolutely perfectly
>
>but http://koha-admin318/cgi-bin/koha/cataloguing/addbooks.pl?q=t is
>fast 
>(~0.7 secs) and finds all the same results plus 73 records in 
>reservoir.  Maybe addbooks.pl doesn't need this $limit (or whatever)
>that 
>search.pl requires, although the results are identical
>
>So, tried Perl debug (I don't know how to input the cookie data for
>admin 
>staff, so this is the opac search, times identical):
>
>koha at hood:/usr/share/koha/opac/cgi-bin/opac$ perl -d -w
>./opac-search.pl ?q=t
>Loading DB routines from perl5db.pl version 1.39_10
>C4::Tags::CODE(0xa633720)(/usr/share/koha/lib/C4/Tags.pm:73):
>73:         $ext_dict and $Lingua::Ispell::path = $ext_dict;
>   DB<1> c
>
>=====>  Romps instantaneously through 16 "Use of uninitialized value" 
>warnings (snipped, basically in "value in string eq",
>$ENV{"SERVER_PORT"} 
>and "value in concatenation (.) or string" in Auth.pm; $index, $_ and
>first 
>mention of $limit in Search.pm) up to
>
>Use of uninitialized value $limit in concatenation (.) or string at 
>/usr/share/koha/lib/C4/Search.pm line 1769.
>  at /usr/share/koha/lib/C4/Search.pm line 1769.
>        C4::Search::buildQuery('ARRAY(0xa7aaea0)', 'ARRAY(0xa7b5b58)', 
>'ARRAY(0xa7aaf60)', 'ARRAY(0xa7b5e58)', 'ARRAY(0xa7aa1b0)', 0, 'en')
>called 
>at opac-search.pl line 473
>
>=====>  stops, no screen action, here for ~19 seconds, then resumes...
>
>Use of uninitialized value $expanded_facet in string eq at 
>/usr/share/koha/lib/C4/Search.pm line 527.
>  at /usr/share/koha/lib/C4/Search.pm line 527.
>         C4::Search::__ANON__[/usr/share/koha/lib/C4/Search.pm:627](1, 
>25397) called at /usr/share/koha/lib/C4/Search.pm line 2567
>         C4::Search::_ZOOM_event_loop('ARRAY(0x72799a8)', 
>'ARRAY(0x72799f0)', 'CODE(0xb0b5878)') called at 
>/usr/share/koha/lib/C4/Search.pm line 628
>         C4::Search::getRecords('(rk=(Title-cover,ext,r1="s" or 
>ti,ext,r2="s" or Title-cover,p...', 's', 'ARRAY(0xa7aa1b0)', 
>'ARRAY(0xa7aad80)', 20, 0, undef, 'HASH(0xa8e8990)', 'HASH(0x7b80a90)',
>
>...) called at opac-search.pl line 552
>         eval {...} called at opac-search.pl line 551
>
>=====>  and romps instantaneously through (snip, basically $priority
>(in 
>Reserves.pm), $expanded_facet, $transfertwhen and plain vanilla "value
>in 
>hash element" in Search.pm) 770 lines of "Use of uninitialized value" 
>warnings, then completes:
>
>Status: 200 OK
>Set-Cookie: CGISESSID=d62edfbbd23aa65c2acea0f49974cb31; path=/;
>HttpOnly
>/... expected HTML, css, scripts, etc .../
></body>
></html>
>
>The complete list of uninitialized values from $ perl 
>-Mdiagnostics=-traceonly ./opac-search.pl ?q=t  runs about 180 lines
>but I 
>can supply it if required.
>
>I can possibly ghost 3.8.5 (also tarball) onto this machine, but I'd
>really 
>like to get 3.18 up and running. I recognize that this install is
>tarball, 
>but it's too late now to make radical changes, it's a big server with a
>lot 
>of other databases and websites.  Nothing new compared to our existing 
>production box, except Ubuntu 14.04.1 LTS and Koha 3.18
>
>Help, pointers, suggestions warmly welcomed.
>
>Thanks -- Paul
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Koha-devel mailing list
>Koha-devel at lists.koha-community.org
>http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>website : http://www.koha-community.org/
>git : http://git.koha-community.org/
>bugs : http://bugs.koha-community.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20150103/ef56109c/attachment.html>