I am trying to use google sheets and api to populate webpages. Even though the sheets aren't that big, the api calls are taking a long time and pages are thus about 10s to load.
How big is the Google Spreadsheet table. These tables are non-server-side tables, which means that the entire table is added to the page using JavaScript, instead of being split per pages (currently visible rows), so if the table is big, it will become slower and slower, until it eventually breaks (no defined limit, as it depends on the server's performance, hosting plan, etc, but 2.000 - 3.000 rows is considered as a big table).
There's nothing in the plugin that would speed it up, as it's already minimized to the max. The API method should be pretty fast, if you have shared hosting you will have to switch to dedicated hosting.
I am trying to use google sheets and api to populate webpages. Even though the sheets aren't that big, the api calls are taking a long time and pages are thus about 10s to load.
Any suggestions or should I not use api?
Thanks
Hi Dave
Thank you for reaching out to us.
How big is the Google Spreadsheet table. These tables are non-server-side tables, which means that the entire table is added to the page using JavaScript, instead of being split per pages (currently visible rows), so if the table is big, it will become slower and slower, until it eventually breaks (no defined limit, as it depends on the server's performance, hosting plan, etc, but 2.000 - 3.000 rows is considered as a big table).
There's nothing in the plugin that would speed it up, as it's already minimized to the max. The API method should be pretty fast, if you have shared hosting you will have to switch to dedicated hosting.