[ckan-dev] ckan-read-performance-optimization

Wed Oct 2 07:17:13 UTC 2019

Hello,

that would be of interest also to me, since in Slovakia we have for 
example something like this:

https://data.gov.sk/dataset/register-adries-ra-zmenove-davky

(i.e dataset with quite a lot of resources)

That was done without agreeing on some more sensible "definition" of 
dataset (i.e. something like used on Czechia, approx.: resources should 
be same data in different format), thuss that Address Registry now 
suffers quite a lot.

I do not want to hijack Sabine's message, just provide additional data. 
Please respond to Swiss case, since IMHO it is more relevant, or at 
least more up-to-date (because Slovak case uses old version of CKAN).

Sincerely

Peter

On 9/23/19 4:58 PM, Sabine Maennel wrote:
> Hello,
> 
> I struggle with CKAN performance optimizations for showing data 
> packages, such as this:
> https://opendata.swiss/de/dataset/health-insurance-premiums
> 
> I monitored postgres and saw that there were a lot of queries in the 
> backend for loading the datapackages. (We are also using 
> ckanext-harvester: so even harvest objects were loaded). I found some 
> advice on cleaning up the database. I will try to do this.
> 
> But on top of that I am wondering whether using Varnish would be an 
> option. Is anyone using Varnish with ckan?
> 
> Would you have any other advice for me on how to monitor and improve the 
> speed of ckan read page loads?
> 
> With kind regards and thanks in advance,
>   Sabine Maennel
> 
> 
> -- 
> Sabine Maennel
> Leimbachstr. 223
> 8041 Zürich
> Tel. +41 (0) 43 53 778 74
> Mathematikerin / Softwareingenieurin
> working at Liip.ch
> 
> sabine.maennel at gmail.com <mailto:sabine.maennel at gmail.com>
> 
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
> 