Hi Bryan.

Thank you for your purchase.

People do use our plugin to create tables with millions of rows, but that's only available for MySQL query based tables, not tables that use external sources like XML, Excel, CSV or Google Spreadsheets.

You can take a look at the following notice in our documentation:

This format will work only up to a certain limit (no exact limit, but 3000-5000 cells is a good example). 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 “Create a table by importing data from data source” option to do this.

_____________________________________________

Also, on the first link provided (Creating MySQL-based tables with server-side processing) you can see another notice:

If the result of MySQL query is quite large (hundreds of thousands, or even millions of rows), and the MySQL queries and tables are not optimized properly (with indexes and proper data types), the tables can still work slow – but wpDataTables isn’t “responsible” for this since the delays are derived from the MySQL engine. Optimize the MySQL tables and queries structure, and wpDataTables will speed up as well!

_____________________________________________

So, with this in mind, I don't believe 22k rows will ever load with this setup. The file is just too large.

Best regards.

Hello again Bryan.

You can simply import the CSV file in PHPMyAdmin (see attachment). If all's good, it should just create the table in your database, and then you can generate a query like:

SELECT
* FROM table_name

I can understand if that doesn't suit your needs.

As for the refund:

Please find our refund policy here: http://wpdatatables.com/help/refund-policy/

Due to the digital 'non-returnable' nature of goods we only do refunds when the tool is malfunctioning or not working as described, with prior confirmation that support is unable to resolve the issue. As the revoked license does not make the product non-functional, and because there were lots of abuses, unfortunately we cannot provide the 'return-on-request' refund policy. So we do not refund mistaken purchases, or cases when buyers had their own expectations of features.

To avoid such situations we have a fully-featured 'sandbox' site where one can try plugin's features before purchase, a free version of the plugin which can help to get a better understanding of how the plugin is working, all the plugin's documentation is available to anyone before purchase, and we try to clear up all the limitations of different features, and we always answer all pre-purchase questions clearly and honestly so that potential buyers would have clear understanding of how the plugin works.

In the end, I'm not the one who can authorize the refund, so if you still want to file a request, you can open it at https://codecanyon.net/refund_requests/new but please note that, usually, this is not something that refund can be given.

Thank you for understanding.

Best regards.

And here's the attachment, sorry.

Best regards.