[Koha-devel] search speed

[Gaetan Boisson]

Well as i said, the time is not the same depending on the number of 
results, but in both cases, the number of results is anyway much higher 
than the number of records taken into consideration for facets.

Your investigation indicates that:

In ZOOM->record, the time is spent in
   my $_rec = Net::Z3950::ZOOM::resultset_record($this->_rs(), $which);

Maybe it's worth having a deeper look in this.

Le 27/05/2015 12:56, Jonathan Druart a écrit :
> 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/

-- 
Gaetan Boisson
Chef de projet bibliothécaire
BibLibre
06 52 42 51 29
108 avenue Breteuil 13006 Marseille
gaetan.boisson at biblibre.com