[Cubicweb] Loading slow a big table using default view

Adrien Di Mascio adrien.dimascio at logilab.fr
Thu Jan 23 13:45:41 CET 2014


Hi,

Le 23/01/2014 13:33, Sylvain Thénault a écrit :
> On 23 janvier 12:24, Jinpeng Li wrote:
>> Dear developers,
>>
>> We found a problem that it is too slow to show a big table using default
>> view. I wrote a description as below with Markdown description. I hope that
>> the description is clear enough to understand. Don't hesitate to let me
>> know if you don't understand any part.
>
> It's very clear, thank your for that.
>
>> We guess that the default view may try to load all the data once and show
>> only first 40 items. In our real database, we have 10 million data, it will
>> take more than 1 minute to open web page where only first 40 items have
>> been shown. It would be to better to improve the default view with loading
>> limited number data items.  If there is another possible reason, please let
>> us know. Thanks in advance.
>
> That may be due to the pagination. Anyway this case deserves investigation.
> Would you open a ticket with the very same description you've just sent?

Pagination doesn't help but I'm pretty sure the main reason for this 
slowness is the default facets (modifcation_date / cw_source / 
created_by) that are computed on the _entire_ resultset.

Cheers,

-- 
Adrien Di Mascio - LOGILAB, Paris (France).
Tél: 01.45.32.03.12
Formations - http://www.logilab.fr/formations
Développements - http://www.logilab.fr/services
Gestion de connaissances - http://www.cubicweb.org/



More information about the Cubicweb mailing list