Title: Maximum Table Size? Last modified: August 20, 2016 --- # Maximum Table Size? * [zmktwzrd](https://wordpress.org/support/users/zmktwzrd/) * (@zmktwzrd) * [14 years, 11 months ago](https://wordpress.org/support/topic/maximum-table-size/) * Is there a maximum table size? I have tried importing a CSV file with approx 1200 rows and 5 columns and WPTR is only showing about 600 of them. Please help! * URL: [Managed Futures](http://www.managedfutures.ws/commodity-trading-advisor-performance/) Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [14 years, 11 months ago](https://wordpress.org/support/topic/maximum-table-size/#post-2170526) * Hi, * likely you are affected by the “Suhosin” problem, a PHP extension on your server that prohibits saving large tables. * Please see the following threads for more, including ideas to fix it: [http://wordpress.org/support/topic/plugin-wp-table-reloaded-cannot-save-changes-for-big-table](http://wordpress.org/support/topic/plugin-wp-table-reloaded-cannot-save-changes-for-big-table) [http://wordpress.org/support/topic/plugin-wp-table-reloaded-import-file-size-uploading-limit](http://wordpress.org/support/topic/plugin-wp-table-reloaded-import-file-size-uploading-limit) [http://wordpress.org/support/topic/plugin-wp-table-reloaded-unable-to-edit-table-data](http://wordpress.org/support/topic/plugin-wp-table-reloaded-unable-to-edit-table-data) [http://wordpress.org/support/topic/wp-table-reloaded-row-limit](http://wordpress.org/support/topic/wp-table-reloaded-row-limit) * Nevertheless, even if you can fix this, I don’t recommend using the plugin for such a large table, as the performance might not be the best. You should get better results with a custom solution that uses PHP/mySQL. * Best wishes, Tobias * [moonpm](https://wordpress.org/support/users/moonpm/) * (@moonpm) * [14 years, 10 months ago](https://wordpress.org/support/topic/maximum-table-size/#post-2170906) * Hi Tobias & zmktwzrd, * I’ve got a db with 800 rows on a Buddypress site recently created- [http://www.artcaritas.com/international-gallery-search](http://www.artcaritas.com/international-gallery-search). * I’m so impressed with WP-table reloaded plugin – excellent! * However, the page loads very slowly about 3 seconds and I’m looking for ways to increased the speed. Quick cache is installed and Minify and that’s improved things but I need to get it much quicker especially as the db is likely to grow in size in the future. * Tobias do you think I should go for a custom solution that uses PHP/mySQ as you suggest above? If so do you know of any tutorials or help to create this? * Thanks in advance for your help – donation on it’s way! * Pauline * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [14 years, 10 months ago](https://wordpress.org/support/topic/maximum-table-size/#post-2170907) * Hi, * unfortunately, I don’t really have ideas on this one. * At first, you should try to find out where the delay comes from. Is it the loading of the actual content (HTML file) or the execution of the JavaScript library? To test that, please temporarily deactivate the usage of the DataTables library for your table and (after clearing your browser cache again), load the page again. If the delay is still there, the problem might indeed be the size of the table in WP-Table Reloaded. In that case, switching to a custom mySQL/PHP solution might help. I don’t have tutorials for this, but anything about PHP/mySQL interaction should be a good starting point. * If the delay vanishes after deactivating the usage of the JS library, the problem basically is the usage of that library. You will then have to either accept the delay or stop using the library… * Regards, Tobias * [moonpm](https://wordpress.org/support/users/moonpm/) * (@moonpm) * [14 years, 9 months ago](https://wordpress.org/support/topic/maximum-table-size/#post-2170940) * Hi Tobias, * Thanks again for your very detailed help and apologies for the delay in updating you on progress. * The problem was the loading of the content and in the end I had to learn how to use Datables Server Side Processing – an extremely steep learning curve I have to say! It didn’t take long to understand the theory but the practice proved challenging to say the least. After a week and a half I cracked it and the table is superfast, see [http://www.artcaritas.com/international-gallery-search](http://www.artcaritas.com/international-gallery-search). It should now be able to display up to 20 million records in the table with no speed issues. * I have thought that maybe I should write an ‘idiots guide’ to how to do this because I’m sure many people who use your plugin will have the same problem. Just finding the time…! * Thanks again for your help. * Pauline * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [14 years, 9 months ago](https://wordpress.org/support/topic/maximum-table-size/#post-2170941) * Hi Pauline, * very good news, the table works nicely on your site! Thanks for the update! * Best wishes, Tobias Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Maximum Table Size?’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/wp-table-reloaded_f7dcd3.svg) * [WP-Table Reloaded](https://wordpress.org/plugins/wp-table-reloaded/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-table-reloaded/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-table-reloaded/) * [Active Topics](https://wordpress.org/support/plugin/wp-table-reloaded/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-table-reloaded/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-table-reloaded/reviews/) * 5 replies * 3 participants * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * Last activity: [14 years, 9 months ago](https://wordpress.org/support/topic/maximum-table-size/#post-2170941) * Status: not resolved