Hello everyone, I'm actually very excited about your plugin. I would like to speed up the Google Sheets and Charts page (https://www.vodametall.de/marktdaten/). Is that possible and what do I have to do? At the moment it takes about 4 seconds to load the page.
When it comes to loading times on one website - this is mostly determined by:
The amount of data on the page
Server performance
Hosting
Internet
Local machine performance
Delayed requests
There is no default loading time, when we create a table with 5 000 rows it takes us less than 1 second to load it but it is all individual as I mentioned above.
I hope this helps to answer your question, don't hesitate to contact us if there is anything else we can assist you with
Thanks for your email. I also don't think that it comes from the plugin itself. But maybe there is a way to accelerate the speed if you call up the tables via, for example, another database?
How are you creating tables from Google Sheets? Was it created through the API or not?
If that also doesn't work, please give us some more details on how the table is created and provide us with the link to the source file so we can test it locally.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Also please provide access to the Google spreadsheet for the following email addresses
The "Too many requests" error is actually telling us that you are using the Sheets API, but there's no way to increase the loading speed of the table or resolve that error.
After exploring this issue further, we found that the Google Sheets API has a quota limit. It's limited to 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user.
That quota can be increased, but that requires an additional charge in Google (increasing the quota is not free). Another way would be to use the old method without the API.
Unfortunately, as your table is getting bigger, it will get slower (since Google Spreadsheet based tables are non-server side tables, they are brought to the table in a whole, and then split into pages using JavaScript), and more Sheets you have, more requests you'll have, so unless you decide to increase the quota (by paying Google), there's no way to avoid that error.
Our developers have been looking into this for a couple of months, but they still haven't found a way around this issue. Sorry for the inconvenience.
Hello everyone, I'm actually very excited about your plugin. I would like to speed up the Google Sheets and Charts page (https://www.vodametall.de/marktdaten/). Is that possible and what do I have to do? At the moment it takes about 4 seconds to load the page.
Hi Christian
Thank you for reaching out to us.
When it comes to loading times on one website - this is mostly determined by:
There is no default loading time, when we create a table with 5 000 rows it takes us less than 1 second to load it but it is all individual as I mentioned above.
I hope this helps to answer your question, don't hesitate to contact us if there is anything else we can assist you with
Thanks for your email. I also don't think that it comes from the plugin itself. But maybe there is a way to accelerate the speed if you call up the tables via, for example, another database?
Any advice would be great!!
Hi Blaženka,
sometimes an error is also displayed (screenshot).
Kind regards
Hi Christian
How are you creating tables from Google Sheets? Was it created through the API or not?
If that also doesn't work, please give us some more details on how the table is created and provide us with the link to the source file so we can test it locally.
Hi Christian
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Also please provide access to the Google spreadsheet for the following email addresses
[email protected]
[email protected]
[email protected]
Hi Christian
Thank you, I have forwarded this to our developers to take a look. I will update you as soon as I get a reply.
We appreciate your time and patience.
Hi Blaženka,
do you have any news for me? Are the accounts still needed and could you reproduce the error? Is there already a solution?
Kind regards
Christian
Hello Christian
Sorry for the late response.
The "Too many requests" error is actually telling us that you are using the Sheets API, but there's no way to increase the loading speed of the table or resolve that error.
After exploring this issue further, we found that the Google Sheets API has a quota limit. It's limited to 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user.
https://developers.google.com/sheets/api/limits
That quota can be increased, but that requires an additional charge in Google (increasing the quota is not free). Another way would be to use the old method without the API.
Unfortunately, as your table is getting bigger, it will get slower (since Google Spreadsheet based tables are non-server side tables, they are brought to the table in a whole, and then split into pages using JavaScript), and more Sheets you have, more requests you'll have, so unless you decide to increase the quota (by paying Google), there's no way to avoid that error.
Our developers have been looking into this for a couple of months, but they still haven't found a way around this issue. Sorry for the inconvenience.
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