Gateway Time-out errors after uploading new coupons
I have latest clipper theme and/with koupon child-theme.
This issue has been happening since I first started using clipper & koupon, for just over 1 year now.
When does the issue occur? How can I recreate the issue?
After I upload a series of coupons (using a third party plugin), the first time i visit the coupon page listing, for example
/page/2/
/page/3/
/page/4/
/etc/...
I get this timeout error/problem/bug/regression:
504 Gateway Time-out
The gateway did not receive a timely response from the upstream server or application.
After the page attempt was made once, the page is cached and the error no longer occurs, the same applies to all the other new pages, and when new coupons get imported, the same issue occurs again.
The big problem here is that search enginee's, reaching such pages to re-indexing page will also see this timeout error, and will not index until a retry at a later date.
Previously I had contacted my host provider, as I'm on shared hosting / but they simply told me the number of queries behind the clipper/koupon themes far exceeds what the server/servers can handle, before those pages are cached, and even if I upgrade to a bigger package there was no assurance that this issue would not re-occur.
After the most recent of clipper/koupon updates, I was hoping that the themes had been tweaked, but this issue is still occurring and has not been resolved...
I have tried different plugins to combine some of the resources, but has not made any difference...
I cannot share public here details of my site, nor can I provide remote access to the server.
This is an issue that should be easy to recreate by uploading a fair number of coupons, so that the number of pages increase, once this has been done, the first time I try to visit the page this problem happens. (Do not retry loading the page, as this will bypass the issue)
Is there anything you guys can do to reduced the amount of queries used by theme when loading a page for the first time?
Can anyone please help me?