<p dir="ltr"><br>
El 28/5/2015 4:43 a. m., "Fridolin SOMERS" <<a href="mailto:fridolin.somers@biblibre.com">fridolin.somers@biblibre.com</a>> escribió:<br>
><br>
> Could this mean one should not get records from Zebra but directly from database ? If getting the id of search results without getting the full record is possible.</p>
<p dir="ltr">It is possible. But we should evaluate the trade-off from preparing the record for display too. Because for indexing we do lots of stuff to the record, stuff that should be done on rendering time with such a change.</p>
<p dir="ltr">><br>
> Le 27/05/2015 21:02, Paul A a écrit :<br>
>><br>
>> At 08:29 PM 5/27/2015 +0200, Gaetan Boisson wrote:<br>
>>><br>
>>> Well as i said, the time is not the same depending on the number of<br>
>>> results, but in both cases, the number of results is anyway much<br>
>>> higher than the number of records taken into consideration for facets.<br>
>>><br>
>>> Your investigation indicates that:<br>
>>><br>
>>> In ZOOM->record, the time is spent in<br>
>>> my $_rec = Net::Z3950::ZOOM::resultset_record($this->_rs(), $which);<br>
>>><br>
>>> Maybe it's worth having a deeper look in this.<br>
>><br>
>><br>
>> I looked into this to some extent in January this year; facets in 3.18<br>
>> <<a href="http://navalmarinearchive.com/z_koha/search_speed_data.html">http://navalmarinearchive.com/z_koha/search_speed_data.html</a>> appeared<br>
>> to be a limiting factor as it "swamped" one CPU core (and NYProf showed<br>
>> this to be from ZOOM - see<br>
>> <<a href="http://navalmarinearchive.com/z_koha/nytprof_318_s/index.html">http://navalmarinearchive.com/z_koha/nytprof_318_s/index.html</a>><br>
>><br>
>> Regards -- Paul<br>
>><br>
>><br>
>>> Le 27/05/2015 12:56, Jonathan Druart a écrit :<br>
>>>><br>
>>>> Gaetan,<br>
>>>> have a look at the metrics on bug 13665.<br>
>>>><br>
>>>> 2015-05-27 11:45 GMT+01:00 Gaetan Boisson <<a href="mailto:gaetan.boisson@biblibre.com">gaetan.boisson@biblibre.com</a>>:<br>
>>>>><br>
>>>>> Hello again all,<br>
>>>>><br>
>>>>> looking at speed issues there is one thing that i don't understand,<br>
>>>>> and i<br>
>>>>> feel some well versed developpers might have a better idea of what is<br>
>>>>> happening.<br>
>>>>><br>
>>>>> If you query zebra directly on the server, it's blazingly fast, no<br>
>>>>> matter<br>
>>>>> how big your database and how many results you get. (At least the<br>
>>>>> difference<br>
>>>>> is negligible, and we still get very low response times.)<br>
>>>>><br>
>>>>> But if you do a search in Koha that brings 20 000 results, it's<br>
>>>>> usualy 4<br>
>>>>> times faster (maybe more, sorry i don't have precise metrics here)<br>
>>>>> than a<br>
>>>>> search that brings up 1 000 000 results.<br>
>>>>><br>
>>>>> Is it consistent with your experience?<br>
>>>>><br>
>>>>> If it is, what would be the reason for this? My understanding is<br>
>>>>> that the<br>
>>>>> search code asks zebra for the first n records to display on the<br>
>>>>> first page,<br>
>>>>> and that facets are based on a number of result way below 20 000<br>
>>>>> anyway, so<br>
>>>>> the total number of results shouldn't really make a difference.<br>
>>>>><br>
>>>>> --<br>
>>>>> Gaetan Boisson<br>
>>>>> Chef de projet bibliothécaire<br>
>>>>> BibLibre<br>
>>>>> 06 52 42 51 29<br>
>>>>> 108 avenue Breteuil 13006 Marseille<br>
>>>>> <a href="mailto:gaetan.boisson@biblibre.com">gaetan.boisson@biblibre.com</a><br>
>>>>><br>
>>>>> _______________________________________________<br>
>>>>> Koha-devel mailing list<br>
>>>>> <a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a><br>
>>>>> <a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
>>>>> website : <a href="http://www.koha-community.org/">http://www.koha-community.org/</a><br>
>>>>> git : <a href="http://git.koha-community.org/">http://git.koha-community.org/</a><br>
>>>>> bugs : <a href="http://bugs.koha-community.org/">http://bugs.koha-community.org/</a><br>
>>><br>
>>><br>
>>> --<br>
>>> Gaetan Boisson<br>
>>> Chef de projet bibliothécaire<br>
>>> BibLibre<br>
>>> 06 52 42 51 29<br>
>>> 108 avenue Breteuil 13006 Marseille<br>
>>> <a href="mailto:gaetan.boisson@biblibre.com">gaetan.boisson@biblibre.com</a><br>
>>><br>
>>> _______________________________________________<br>
>>> Koha-devel mailing list<br>
>>> <a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a><br>
>>> <a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
>>> website : <a href="http://www.koha-community.org/">http://www.koha-community.org/</a><br>
>>> git : <a href="http://git.koha-community.org/">http://git.koha-community.org/</a><br>
>>> bugs : <a href="http://bugs.koha-community.org/">http://bugs.koha-community.org/</a><br>
>>><br>
>><br>
>> ---<br>
>> Maritime heritage and history, preservation and conservation,<br>
>> research and education through the written word and the arts.<br>
>> <<a href="http://NavalMarineArchive.com">http://NavalMarineArchive.com</a>> and <<a href="http://UltraMarine.ca">http://UltraMarine.ca</a>><br>
>><br>
>> _______________________________________________<br>
>> Koha-devel mailing list<br>
>> <a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a><br>
>> <a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
>> website : <a href="http://www.koha-community.org/">http://www.koha-community.org/</a><br>
>> git : <a href="http://git.koha-community.org/">http://git.koha-community.org/</a><br>
>> bugs : <a href="http://bugs.koha-community.org/">http://bugs.koha-community.org/</a><br>
><br>
><br>
> -- <br>
> Fridolin SOMERS<br>
> Biblibre - Pôles support et système<br>
> <a href="mailto:fridolin.somers@biblibre.com">fridolin.somers@biblibre.com</a><br>
><br>
> _______________________________________________<br>
> Koha-devel mailing list<br>
> <a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a><br>
> <a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
> website : <a href="http://www.koha-community.org/">http://www.koha-community.org/</a><br>
> git : <a href="http://git.koha-community.org/">http://git.koha-community.org/</a><br>
> bugs : <a href="http://bugs.koha-community.org/">http://bugs.koha-community.org/</a><br>
</p>