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

Mon Sep 23 14:58:19 UTC 2019

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20190923/3beff899/attachment-0001.html>