[Koha-bugs] [Bug 13665] Retrieve facets from zebra is slow

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13665

Hugo Agud <hagud at orex.es> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |hagud at orex.es

--- Comment #4 from Hugo Agud <hagud at orex.es> ---
We have faced a similar issue about zebra facet performance, but we have
identified another variables that affect the zebra performance



We were working with koha 16.05.05 debian 8 plack enabled, 4 cpu , 8 RAM + 100
GB on SSD.

>From fresh install, load a database of 225.000 bib records + 300.000 authority
+ 260.000 item record.

When searching we found that stopwords increase the time response up to 12
times...

Koha Search: Felipe Rey España (15 secons)
Koha Search: Felipe Rey de España (110 seconds)

If we turn on queryfuzz and query stemming the speed increase sharply

Koha Search: Felipe Rey España (5 secons)
Koha Search: Felipe Rey de España (20 seconds)

If we turn on zebra facets, it becomes very fast
Koha Search: Felipe Rey España (1,5 secons)
Koha Search: Felipe Rey de España (2,5 seconds)


If we turn off zebra facet and keep query steemming and qeryfuzzy on it has the
same performance behaviour that turning off facets

Koha Search: Felipe Rey España (5 secons)
Koha Search: Felipe Rey de España (20 seconds)

then here we have a mix of issues with stopwords, querystemming, queryfuzzy and
zebra facets.

Hope it helps

-- 
You are receiving this mail because:
You are watching all bug changes.