Maximum Table Size?

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:
https://www.ads-software.com/support/topic/plugin-wp-table-reloaded-cannot-save-changes-for-big-table
https://www.ads-software.com/support/topic/plugin-wp-table-reloaded-import-file-size-uploading-limit
https://www.ads-software.com/support/topic/plugin-wp-table-reloaded-unable-to-edit-table-data
https://www.ads-software.com/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

Hi Tobias & zmktwzrd,

I’ve got a db with 800 rows on a Buddypress site recently created- https://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

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

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 https://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

Hi Pauline,

very good news, the table works nicely on your site!
Thanks for the update!

Best wishes,
Tobias