Hi Stephen,
Thank you for your purchase.

Can you please tell me which table type (Excel,CSV, Mysql...) did you use for creating the table.

Thank you.

Hi Stephen

Ok I will try to explain you how the CSV tables works to get a clear picture:

CSV based tables works on client side. What that mean is when client request data from your web server whole table load at once. All further processing like searching and sorting is done on client side, in client browser and speed of it depends on client machine specification. 

I assume that your site works a little bit slow so my suggestion will be to import that data in the MySQL with Table Constructor or through phpMyAdmin. This would allow you to use it with server side processing which retrieves only number of rows that you specified in table settings and on search sort or pagination send requests for new data to server. So for example if you specified 10 rows per page only those 10 rows would be retrieved. This could increase table usability drastically for very large table but I'm not sure that it will add any significant benefit in your case because constantly sending and retrieving data from server adds some load time as well.

You can find demo of the table with server side processing here.

Also from our documentation for Creating Tables from CSV you will find this notice

When working with CSV-based wpDataTables please note: this format is fine only till a certain limit (no exact limit, but let’s say 3000-5000 cells), if you have a larger file, the page load time will increase. For large data sets it makes sense to import the data to MySQL, you can use wpDataTables Table Constructor to do this.

Hope this can help.

Best regards.

Hi Stephen,


Glad to help you out.
You are welcome.

Best regards.