Hi,
thanks for your question, and sorry for the trouble.
While there is no limit in theory, this would probably be too much for TablePress to handle from a practical point of view. With that I mean that the performance will probably not be the best, and managing and editing the tables will also be hard.
For a scenario like this, a custom PHP/mySQL solution should therefore be better.
TablePress stores the tables as JSON-encoded strings in the wp_posts database table. The table name is in the title field. The table IDs (and their mapping to the corresponding post IDs) are stored in the tablepress_tables entry in the wp_options database table, as a JSON encoded array.
Regards,
Tobias
Hi Tobias, thank you for the fast response and your advise on using custom PHP/mySQL solution. I would still give tablepress a try as I won’t be editing the tables, only replacing the html files at the server and hope the auto-update will take care of it.
Thank you very much for pointing the data stored in which table. I was looking everywhere on where it stores. I might need to link both tables outside of sql function to get the tablepress table id and tablepress table name.
Hi,
no problem, you are very welcome! 🙂
Yes, giving TablePress a try is of course possible. Maybe it does satisfy your needs. The Auto Import will however also not be very reliable with 1500 tables, from what I can estimate.
Best wishes,
Tobias
Hi Tobias, just wanna update you here on my attempt. It took me quite sometime to automate the uploading and scripting but alas I encountered this error when I click ‘Save Auto Import Configuration’ at line 200. Guess that’s the limit.
“Error: The source for the import is invalid or could not be accessed.”
It seems to be working now after increasing value for max_input_vars! 300+ and counting to 1500..
Hi,
yeah, for many tables, such server limits can kick in, which means that you’ve have to raise these values. Nice find!
Best wishes,
Tobias
