We have a petition with 20+ thousand signatures for a petition and we are wanting to display it on our website. It is in google sheets and is updated automatically... can your product do this?
Google Spreadsheets table format will work only up to a certain limit (no exact limit, but 3000-5000 cells is a good example).
When your data set is larger than a couple of thousand rows, it can’t effectively be loaded in the page. It first reads the data from the source, and then prints out the complete table data on your page; so, as the row count grows, it makes both the page generation time on server side and the page load and initialization time on client side, slower and slower. If your host has a certain memory or timeout limit defined for PHP scripts, it can ‘break’ the page, because the script would try to allocate more memory than it’s allowed.
So if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL).
We have a petition with 20+ thousand signatures for a petition and we are wanting to display it on our website. It is in google sheets and is updated automatically... can your product do this?
Hi Wyatt
Thank you for reaching out to us.
Google Spreadsheets table format will work only up to a certain limit (no exact limit, but 3000-5000 cells is a good example).
When your data set is larger than a couple of thousand rows, it can’t effectively be loaded in the page. It first reads the data from the source, and then prints out the complete table data on your page; so, as the row count grows, it makes both the page generation time on server side and the page load and initialization time on client side, slower and slower. If your host has a certain memory or timeout limit defined for PHP scripts, it can ‘break’ the page, because the script would try to allocate more memory than it’s allowed.
So if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL).