Gaetan, have a look at the metrics on bug 13665.
2015-05-27 11:45 GMT+01:00 Gaetan Boisson <[email protected]>: > Hello again all, > > looking at speed issues there is one thing that i don't understand, and i > feel some well versed developpers might have a better idea of what is > happening. > > If you query zebra directly on the server, it's blazingly fast, no matter > how big your database and how many results you get. (At least the difference > is negligible, and we still get very low response times.) > > But if you do a search in Koha that brings 20 000 results, it's usualy 4 > times faster (maybe more, sorry i don't have precise metrics here) than a > search that brings up 1 000 000 results. > > Is it consistent with your experience? > > If it is, what would be the reason for this? My understanding is that the > search code asks zebra for the first n records to display on the first page, > and that facets are based on a number of result way below 20 000 anyway, so > the total number of results shouldn't really make a difference. > > -- > Gaetan Boisson > Chef de projet bibliothécaire > BibLibre > 06 52 42 51 29 > 108 avenue Breteuil 13006 Marseille > [email protected] > > _______________________________________________ > Koha-devel mailing list > [email protected] > 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/ _______________________________________________ Koha-devel mailing list [email protected] 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/
