Ckan: CKAN 2.9 extremely slow rendering

[debbielee1996]

CKAN version
2.9

Describe the bug
When I host my project, the initial rendering of pages can be very slow, up to 5 minutes. On localhost it is extremely fast which is normal

Steps to reproduce
Steps to reproduce the behavior:

1. change host and site_url of ckan.ini
2. run project
3. access pages

Expected behavior
Smooth rendering of pages. but instead I got stuck with a page that takes about 3-5 minutes to load, or unless I click the same button for the second time. On every single page

[kowh-ai]

@debbielee1996 - really difficult to know what is going on without more information - to me it looks like the page rendering is waiting for some sort of timeout...something network related _or_ perhaps DNS...

[debbielee1996]

Unfortunately, there's no specific error messages on the debugger console. I set up CKAN 2.9 in the same way as I set up CKAN 2.8. CKAN 2.8 works fine when I host it, but CKAN 2.9 will take extremely long to render a single page that has never been rendered before... Did you have this issue when you host CKAN 2.9? I am currently hosting it in my Ubuntu VM and accessing it from my Windows host machine.

[kowh-ai]

I have a Mac OS X environment with Ubuntu VM's running. I don't have this issue and even with Debugging on it shouldn't take 3-5 minutes to load a page. I presume it's the same for Python3 and Python2?

[fulior]

@debbielee1996 were you able to find out what is causing this issue? I'm experiencing the same, upgrade from 2.8.6 to 2.9.1, local environment works fine, shared environment (behind uwsgi and nginx) is really slow, I mean main page loading takes more than 30 seconds with almost 0 load on CPU on the server or the DB with 2.9.1, where with 2.8.6 it's half a second on the same hardware.

[debbielee1996]

Hey @fulior, I didn't manage to resolve it. I used back CKAN 2.8 instead.