[Koha-devel] search speed

[Jonathan Druart]

Gaetan,
have a look at the metrics on bug 13665.

2015-05-27 11:45 GMT+01:00 Gaetan Boisson <gaetan.boisson at biblibre.com>:
>  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
> gaetan.boisson at biblibre.com
>
> _______________________________________________
> 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/