[Koha-devel] 3.18 search speed
Paul A
paul.a at navalmarinearchive.com
Mon Jan 5 18:24:33 CET 2015
At 10:48 PM 1/3/2015 -0700, Christopher Davis wrote:
>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.
Christopher,
Thanks for your reply -- we have none of the "services" (including cover
images, etc) turned on. Yesterday I verified every page in Home :
Administration : System preferences (and compared to our workhorse 3.8.5
installation) to make sure we have a truly no-frills environment.
Regards -- Paul
>HTH,
>
>Christopher Davis, MLS
>Systems & Electronic Services Librarian
>Uintah County Library
>cgdavis at co.uintah.ut.us
>(435) 789-6261
><http://uintahlibrary.org>uintahlibrary.org
><http://facebook.com/uintahcountylibrary>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>http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>
>
>website : <http://www.koha-community.org>http://www.koha-community.org/
>
>
>git : <http://git.koha-community.org>http://git.koha-community.org/
>
>
>bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/
---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>
More information about the Koha-devel
mailing list