It's not recommended loading that amount of data on your website.
When your data set is larger than a couple of thousand rows, it can’t effectively be loaded in the page from a Google Spreadsheet, a CSV or Excel file, or other sources. Each of these methods 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.
This is why it's recommended to load only a number of rows on a page. Going above 2.000 - 3.000 rows is not recommended.
Downloading the less result works fine, unfortunately the maximum max_execution_time that our current server provide is up to 597 only, based on your test of 10,000 rows, how long it takes to download that? , So it means, that Report Builder is not compatible for huge data reporting for example 20,000 - 30,000 data? I Try to setup a wordpress in my local and try to download the report of 20,000 data, but it takes about an hour or two to download the data, sometimes it return 500 error.
Report Builder can handle large amount of data, but it needs a good server, good hosting plan and a lot of resources (execution time, timeout time, memory limit, etc) to be able to handle that many rows.
When we tested on 10.000 rows, it took about 15 - 20 minutes for the report to generate.
The page is not loading when we try to load all 19,000 + data on our site.
Hello Sunny Cris Fortunato
Thank you for your purchase.
It's not recommended loading that amount of data on your website.
When your data set is larger than a couple of thousand rows, it can’t effectively be loaded in the page from a Google Spreadsheet, a CSV or Excel file, or other sources. Each of these methods 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.
This is why it's recommended to load only a number of rows on a page. Going above 2.000 - 3.000 rows is not recommended.
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
Hi Aleksandar,
Thanks for the reply,
Downloading the less result works fine, unfortunately the maximum max_execution_time that our current server provide is up to 597 only, based on your test of 10,000 rows, how long it takes to download that? , So it means, that Report Builder is not compatible for huge data reporting for example 20,000 - 30,000 data? I Try to setup a wordpress in my local and try to download the report of 20,000 data, but it takes about an hour or two to download the data, sometimes it return 500 error.
Regards,
Sunny
Hello again Sunny
Report Builder can handle large amount of data, but it needs a good server, good hosting plan and a lot of resources (execution time, timeout time, memory limit, etc) to be able to handle that many rows.
When we tested on 10.000 rows, it took about 15 - 20 minutes for the report to generate.
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