Hello,
We would like to begin by extending our heartfelt apologies for the delay in our response, which is due to an unusually high volume of tickets. We sincerely regret any inconvenience this may have caused, and we truly appreciate your patience during this time.
In regards to your questions :
1. In regards to slow load, The loading speed depends on a lot of factors – your hosting plan, server’s performance, amount of other data on the page, internet speed, etc.
For example, you can take a look at this SQL table on our documentation , which contains around 2.600.000 rows, and see how it loads. The more data the table has, the more chance that it will impact the loading time.
When it comes to tables linked to a CSV file specifically ( same goes for Excel, Google Sheet, basically all tables which are not SQL based), it depends how many rows that CSV has. You can try with our Cache and Auto Update cache feature (https://wpdatatables.com/documentation/table-features/caching-data-and-auto-update-cache-in-wordpress-tables/) this can help with the load time significantly for tables that have approximately between a thousand and 5 thousand rows, but we still recommend keeping the data in these files down to around 5.000 rows.
If your source data goes above that size, then you can try our server-side processing feature for SQL based Tables,
but that is not available in the free version.
If you need more details about any premium options,
please open a ticket on our main Support platform here,
and one of our Agents will respond as quickly as possible.
Premium products are not supported in these forums, as per this comment by ww.wp.xz.cn moderators.
Thank you for understanding.
3. When it comes to a configuration from the Hosting’s End, there is no ‘universal’ configuration, but a general rule is that , the higher you can get their PHP Memory Limit, the more data your WordPress Page will be able to handle. Same goes for PHP TimeOut limit, the higher you set it , your WordPress will be able to handle any kind of a ‘time out’ error in general.On this Page you can see a useful Article from wpBeginners, they advise what might be best as hosting configuration : https://www.wpbeginner.com/beginners-guide/how-to-host-a-website/ And here you can see their recommended list of Hosting Providers : https://www.wpbeginner.com/wordpress-hosting/
We hope that helps.
Kind regards.
