Title: Tablepress limits
Last modified: November 7, 2016

---

# Tablepress limits

 *  Resolved [bursainsights](https://wordpress.org/support/users/bursainsights/)
 * (@bursainsights)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/tablepress-limits/)
 * I’m amazed with tablepress capabilities and wonder if this will suit my needs.
   Would I be able to create 1,500 tables with 15 columns each? and use auto-import
   extension plugin to update the 1,500 tables automatically? Would I exceed the
   limit that tablepress can support? Is there a limit by the way?
 * Also, where can I retrieve the table id and table name list. Is tablepress using
   MySQL database?

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/tablepress-limits/#post-8405264)
 * 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
 *  Thread Starter [bursainsights](https://wordpress.org/support/users/bursainsights/)
 * (@bursainsights)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/tablepress-limits/#post-8408336)
 * 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.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/tablepress-limits/#post-8409025)
 * 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
 *  Thread Starter [bursainsights](https://wordpress.org/support/users/bursainsights/)
 * (@bursainsights)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/tablepress-limits/#post-8478946)
 * 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.”
 *  Thread Starter [bursainsights](https://wordpress.org/support/users/bursainsights/)
 * (@bursainsights)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/tablepress-limits/#post-8479427)
 * It seems to be working now after increasing value for max_input_vars! 300+ and
   counting to 1500..
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/tablepress-limits/#post-8479755)
 * 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

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Tablepress limits’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [9 years, 5 months ago](https://wordpress.org/support/topic/tablepress-limits/#post-8479755)
 * Status: resolved