Can you please test your existing Google Spreadsheet on our sandbox site?
My guess is that they will load faster, simply because we're on a different server. If you can confirm that your Google Spreadsheet files load faster when placed on front-end on our sandbox, then I can say that this is happening due to your server's performance. The data is being pulled using CURL, and we don't have any caching for tables connected to an existing Google Spreadsheet. That's why they are being loaded every time on page load, or page refresh.
I'm using this plugin to load lunch menu items and descriptions for a daily menu that can be updated from a Google Sheet.
There are only about 50 items in 11 tables.
The pages load extremely slowly. Each one take 15-30 seconds to load. Here's a link to a fully loaded menu page: https://miartisan-ppsj.com/cafe/mon_17/
I have tested and loading the same page with no WPDataTables takes under 2 seconds. Here's a link to that page: https://miartisan-ppsj.com/tms-support-test-menu-page/
That said, loading the back-end Google sheet that the data is loading from also takes only 1-2 seconds.
What can I do to speed this process up?
Hello Omar
Can you please test your existing Google Spreadsheet on our sandbox site?
My guess is that they will load faster, simply because we're on a different server. If you can confirm that your Google Spreadsheet files load faster when placed on front-end on our sandbox, then I can say that this is happening due to your server's performance. The data is being pulled using CURL, and we don't have any caching for tables connected to an existing Google Spreadsheet. That's why they are being loaded every time on page load, or page refresh.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables