Row Number Limit

Hi,

thanks for your post, and sorry for the trouble.

Yeah, I know what you mean, and I have experienced it myself. Unfortunately, I haven’t found a good solution yet, but I hope to be able to make this better when I rewrite the “Edit” screen in the future.

The problem usually is that the web browser has problems handling the large number of input fields. Some users have achieved a faster performance when using Internet Explorer here (yes, that’s surprising), which presumably has a better management of those input fields.

A workaround would be to edit the table externally, e.g. in Excel, and then re-importing it from a CSV file, choosing to replace the existing table.

For the future, I plan to completely rewrite the “Edit” screen with a much better performance for large tables in mind. This will however still take some time.

So, no, there’s no direct limit for the number of rows, this is simply a performance issue with browsers.

Regards,
Tobias

Thank you for the quick reply. I think there is limit saying you exceed the limit when we try importing 6000 rows.

Hi,

it’s not really the number of rows, but the number of text fields (so rows times columns). Then, depending on the browser, the computer’s memory, etc. you see the slowness.
At the moment, the best work around is to then not edit this large table in TablePress, but e.g. in Excel and then only import it again.

Regards,
Tobias

Is there away to edit or upload this large amount from the database?

If yes in which table the data is stored?

Hi,

I’m not really sure what you mean here. TablePress does not support accessing databases, sorry.

Tables themselves are stored as JSON-encoded two-dimensional arrays, as “Custom Post Types” in the wp_posts table. They have a post_type value of tablepress_table.

Regards,
Tobias