https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13665
Hugo Agud <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Hugo Agud <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
