davez
Member
Hi,
I've run into a list loading issue that I just can't resolve, and have been battling with it for quite sometime. I've brought the load time down from 1 minute to maybe 30 seconds. At times, it loads quickly just a few seconds. Oddly, this happens when the cache is turned on or off. It's hosted on SiteGround (shared), this host has always been excellent for me. I have the site on both a live site and a dev site (which are on different servers). I've worked with SiteGround and they don't see an issue with errors on their server.
The main issue is the loading of a list. Details:
- Presently it only has roughly 2000 rows.
- It has two direct joins (only one of which shows two columns in list view), two databasejoin elements and two user elements.
- The linkage to the joins keys in the database and are set up properly (it seems).
- In list view I removed the viewable elements from the joined tables.
- In the list view there is one calc element that does calculate on each load, but turning that off does not seem to help.
- I have made sure the database collation is the same.
- I have tried various cache settings, as well as turning off/on the cache in List > Advanced.
- I have turned off the loading of elements in list view that are not essential to the list search or display.
- optimized tables
- I turned on debug Joomla and Fabrik to simplify what I could find. There a number of duplicate queries. But fixing that only helped slightly.
Some of the above helped, but something else is eating up resources. I've never had this particular issue and have many Joomla/Fabrik sites.
I've added my site credentials to the Fabrik My Sites page. This is for the wic_permits table. The joined tables are wic_itinerary and wic_invoices.
What am I missing? Joomla debug is currently turned on on the DEV site.
https://scci.interactive-earth.com/admin/all-permits.html
Any hints of solutions would be greatly appreciated!
I've run into a list loading issue that I just can't resolve, and have been battling with it for quite sometime. I've brought the load time down from 1 minute to maybe 30 seconds. At times, it loads quickly just a few seconds. Oddly, this happens when the cache is turned on or off. It's hosted on SiteGround (shared), this host has always been excellent for me. I have the site on both a live site and a dev site (which are on different servers). I've worked with SiteGround and they don't see an issue with errors on their server.
The main issue is the loading of a list. Details:
- Presently it only has roughly 2000 rows.
- It has two direct joins (only one of which shows two columns in list view), two databasejoin elements and two user elements.
- The linkage to the joins keys in the database and are set up properly (it seems).
- In list view I removed the viewable elements from the joined tables.
- In the list view there is one calc element that does calculate on each load, but turning that off does not seem to help.
- I have made sure the database collation is the same.
- I have tried various cache settings, as well as turning off/on the cache in List > Advanced.
- I have turned off the loading of elements in list view that are not essential to the list search or display.
- optimized tables
- I turned on debug Joomla and Fabrik to simplify what I could find. There a number of duplicate queries. But fixing that only helped slightly.
Some of the above helped, but something else is eating up resources. I've never had this particular issue and have many Joomla/Fabrik sites.
I've added my site credentials to the Fabrik My Sites page. This is for the wic_permits table. The joined tables are wic_itinerary and wic_invoices.
What am I missing? Joomla debug is currently turned on on the DEV site.
https://scci.interactive-earth.com/admin/all-permits.html
Any hints of solutions would be greatly appreciated!