[ckan-dev] Preview from datastore, count(*) takes very long time on large resources.

• Previous message: [ckan-dev] How to avoid hyperlink creation when writing down URIs in markdown?
• Next message: [ckan-dev] Preview from datastore, count(*) takes very long time on large resources.
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I've got several large resources where the datastore contains 8-11 mio. rows.

Previewing those takes a very long time, which seems to be caused by the:
count(*) over() AS "_full_count"
which occurs in the SQL called.

Could this call be placed elsewhere or could something else be done?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20131211/a4bdc6f5/attachment-0002.html>

• Previous message: [ckan-dev] How to avoid hyperlink creation when writing down URIs in markdown?
• Next message: [ckan-dev] Preview from datastore, count(*) takes very long time on large resources.
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]