Limits to TablePress?

Hi,

you seem to have a very cooperative webhost! Their investigations are really nice and helpful! I haven’t seen a webhost who even investigates the source code of a plugin that seems to cause such plugins before, so that’s very cool. Please send them a thank you from me! 🙂

Now, unfortunately I can’t give estimates on whether, or how, I can use this information to make the plugin better usable with many tables. I have some ideas, but I need some time to think about, to implement, and to test them. It definitely looks promising though.
So, unfortunately, until I have a solution to this that I can add to the plugin, I’m out of ideas on how I could help you right now 🙁 Sorry.

Regards,
Tobias

Hi,

I can understand your situation, but have to take the defensive route here: I won’t be able to have a solution in place by midday tomorrow, and maybe not even until after the weekend. Sorry.
Exploring other options is the best idea for now, for your situation.

Using WP-Table Reloaded and TablePress together is possible, but needs some extra work. The first reason is that both plugins use the same WordPress Shortcode [table]. This can easily be circumvented, if you change the WP-Table Reloaded Shortcode with the help of the instructions at http://tobias.baethge.com/2010/01/extension-3-changing-the-table-shortcode/ You could change it to [wptrtable] for example.
The second reason is the CSS styling, which is slightly different in both plugins. Here, I recommend to deactivate the Default and Custom CSS in WP-Table Reloaded entirely, and to use the TablePress CSS for the tables from both plugins. This will also guarantee a uniform styling of your tables. To achieve that, just paste the lines

add_filter( 'wp_table_reloaded_table_css_class', 'wptr_add_tablepress_classes', 10, 2 );
function wptr_add_tablepress_classes( $classes, $table_id ) {
  $classes[] = 'tablepress';
  $classes[] = 'tablepress-id-' . $table_id;
  return $classes;
}

to your functions.php (or actually to the Extension that changes the Shortcode, to keep everything together).
After that, all tables will have the TablePress styling.

Note that this is not really a long-term solution. as WP-Table Reloaded will be discontinued soo. Unless I’m able to find a solution to the actual issue in TablePress, you might need to look into a custom PHP/mySQL database solution. Unfortunately, I also don’t know other table plugins that could handle your amount of tables (which is indeed more than the average user has).

Regards,
Tobias

Hi,

thanks for that note as well!
I’m not really sure why they come to that conclusion though. TablePress only stores a small list with the table IDs, and their post IDs in the wp_options table. This really is not a lot of data, and actually much less than for example WP-Table Reloaded stores there… (Basically, this was one of the reason why I decided to completely rewrite the plugin.)

Regards,
Tobias

Hi,

yes, I can understand the point about not loading all the tables in one batch. That makes sense, and I’ll investigate ideas to change this.
I was just confused, because the suggestion with the “wp_options” doesn’t really fit into that description.

And thanks for their contact details! If I need more information, I’ll ask them directly! Thanks!

Best wishes,
Tobias

Hi,

ah, ok. Thanks for that feedback!
The data in wp_options is really only a list, that maps table IDs to post IDs. It’s not that important for the export/backup. The easiest way for that is to use the TablePress Bulk Export feature, with JSON as the format, as that will also include all table options and not just the data.

Best wishes,
Tobias

Hi,

this is not a really an error due to a bug in the code, and it can not just be “overridden”. It is an error due to limited ressources (in this case the memory that PHP is allowed to use). So, to fix this, you’ll need to increase the available memory limit (which probably is not possible), or reduce the amount of memory that is actually used. The easiest way for that is to deactivate a few “big” other plugins while editing tables in TablePress. It might even be enough to temporarily deactivate WP-Table Reloaded, and the re-activate it after your done editing tables in TablePress. I know, this is an ugly solution, but it is the only thing that will work, until I can implement a long-term solution that does not load all tables at once.

Regards,
Tobias