A table this big would have to be a server-side table, so either imported through the plugin, or imported directly in the database, and pulled using an SQL query.
The plugin can handle tables with millions of records, but rendering of such large tables depends on your server's performance and hosting plan. If you have a good server, and a good hosting plan, you should have no issues creating a table this big. It may load slower than smaller tables, but since server-side processing only pulls the rows currently displayed on the page, if you set that to be 10, 25, 50 or 100 rows, it should still be relatively fast.
I have database tables with almost 200,000 records. Will this plugin be able to handle a dataset of that size?
Hello Ron
Thank you for your interest in our plugin.
A table this big would have to be a server-side table, so either imported through the plugin, or imported directly in the database, and pulled using an SQL query.
The plugin can handle tables with millions of records, but rendering of such large tables depends on your server's performance and hosting plan. If you have a good server, and a good hosting plan, you should have no issues creating a table this big. It may load slower than smaller tables, but since server-side processing only pulls the rows currently displayed on the page, if you set that to be 10, 25, 50 or 100 rows, it should still be relatively fast.
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