I have a large table with almost 40,000 lines that I would like to present in a searchable format on my website. I have tried a number of other plugins both free and paid and none have been able to load the table fast enough to prevent lag. I don't want my viewers to wait when performing a search within the table. I have tried loading different chunk sizes and nothing seems to make the table load instantly. I'm assuming that sites like www.whitepages.com must use a different method as there is no lag. I have tried trhe free version of your plugin and the table didn't even load at all. Can the pro version of your tables plugin accomplish what I would like in a fast loading table? Also, I would like the table to only show a search field without showing any rows similar to whitepages.com. Any help would be greatly appreciated. Thanks, Sab
While the plugin can handle tables with millions of rows, the speed of load depends on a lot of factors (hosting plan, server configuration, internet speed, amount of data on the site or on the page, etc.).
You can take a look at our documentation, where you can see a table with 2,560,000 rows, and it loads pretty fast (a few seconds). It takes around 6 seconds to filter the table (to select a value from a single-value select-box, and display it in the table).
The key is server-side processing, where only the rows displayed on the page are being fetched from the database, and that increases the speed of load.
What you tried with the Lite version of wpDataTables are tables linked to an existing data source (Excel, CSV, Google Spreadsheet, PHP, XML, or JSON), and they don't have server-side processing. Those sources can be used for tables with 2.000 - 3.000 rows, and the larger the source gets, the slower it is, until it eventually breaks, and doesn't load.
If you purchase the plugin, you have 15 days to try it out. If it doesn't fit your needs, you can submit a refund request within that period of time, and we'll refund your purchase.
I have a large table with almost 40,000 lines that I would like to present in a searchable format on my website. I have tried a number of other plugins both free and paid and none have been able to load the table fast enough to prevent lag. I don't want my viewers to wait when performing a search within the table. I have tried loading different chunk sizes and nothing seems to make the table load instantly. I'm assuming that sites like www.whitepages.com must use a different method as there is no lag. I have tried trhe free version of your plugin and the table didn't even load at all. Can the pro version of your tables plugin accomplish what I would like in a fast loading table? Also, I would like the table to only show a search field without showing any rows similar to whitepages.com. Any help would be greatly appreciated. Thanks, Sab
Hello Sab
Thank you for your interest in wpDataTables.
While the plugin can handle tables with millions of rows, the speed of load depends on a lot of factors (hosting plan, server configuration, internet speed, amount of data on the site or on the page, etc.).
You can take a look at our documentation, where you can see a table with 2,560,000 rows, and it loads pretty fast (a few seconds). It takes around 6 seconds to filter the table (to select a value from a single-value select-box, and display it in the table).
The key is server-side processing, where only the rows displayed on the page are being fetched from the database, and that increases the speed of load.
What you tried with the Lite version of wpDataTables are tables linked to an existing data source (Excel, CSV, Google Spreadsheet, PHP, XML, or JSON), and they don't have server-side processing. Those sources can be used for tables with 2.000 - 3.000 rows, and the larger the source gets, the slower it is, until it eventually breaks, and doesn't load.
If you purchase the plugin, you have 15 days to try it out. If it doesn't fit your needs, you can submit a refund request within that period of time, and we'll refund your purchase.
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