Is there a limit to the size of the csv file that csvtable and datatable can handle? Or is this something that is set by my server?
I tested the component with one small dataset (50 records) and it worked great, but when I tried it on another dataset (5000 records) it resulted in a 500 error.

I suspected that I might be better off putting these larger datasets into MySQL, but just wanted to see how it fared under these two plugins, since they are simple and intuitive for users. Now I just want to be certain that it really is the size and not something else that is giving me the error.

Thanks,
Barry

Hello,

Limit of CSV file size depends on available memory. You can see memory which allocated for running script on 'Help->System Info->PHP Information' page on your Joomla backend on 'memory_limit' option, also it can have problem with large datasets because DataTable plugins such as ARI JDataTable, ARI JTableSorter and other handle data on client-side, it can work normally with ~1000-2000 rows in dataset. We are goingo to remove this limitation and AJAX support to DataTable plugin in one of the future releases.

Regards,
ARI Soft

Thanks !

Admin -- that is good news. Do you have an idea as to when that would be available?

I have a CSV file with 2397 rows and the page just shows as blank when I try and display the file in a data table. Any tips?

You can try to use PHP Settings plugin that increase value of 'memory_limit' PHP setting. Set it to '256M' for example.

Regards,
ARI Soft