Support for large tables?

  • stormflora

    (@stormflora)


    6 years, 8 months ago

    Hi, I’m trying this out for the first time. I noticed that if I add more than several hundred rows (I need a large database), the TablePress editor page lags really badly because it tries to load every single row onto the same page.

    Is there any chance you could optimize this to display only say, 100 rows in the editor at a time (like how it looks to visitors)? That would greatly help with editing optimization, and I think it would improve the plugin further.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 8 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    This is a known issue, but unfortunately, there’s no decent solution yet. Offering pagination on that screen is not directly possible, due to the way how tables are saved, unfortunately.

    For now, the best workaround is to manage such large tables offline, e.g. in Excel, and then save them as a CSV file after making changes, and re-importing that CSV file, choosing to replace the existing copy of the table.

    Regards,
    Tobias

    Thread Starter stormflora

    (@stormflora)

    6 years, 8 months ago

    I see; I didn’t realize that WordPress had limitations like that.

    Then, what is the proper CSV (text) format for the table? How is each column separated?

    • This reply was modified 6 years, 8 months ago by stormflora.
    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 8 months ago

    Hi,

    TablePress best supports CSV files with , or ;. It’s important though that this column separator is escaped if used inside a table cell, just like the ".
    If you use Excel or similar, the saved/exported CSV files will work fine.

    Regards,
    Tobias

    Thread Starter stormflora

    (@stormflora)

    6 years, 8 months ago

    So you suggest simply editing the tables in Excel and then replacing the table on the site each time with the new revision then.

    In that case, I think it would be a good idea to separate the table editor from the table settings. That way, you can edit the settings for a table without having to load the entire table for it, and only load up the table editor if necessary.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 8 months ago

    Hi,

    yes, that’s basically the idea with Excel!

    Thanks for that suggestion! I’ll check whether that can be a viable option in the future, though it might be confusing as well…

    In the meantime, if you need to change settings for a table, I recommend to import a small/empty dummy table, then make the changes, and then upload the actual table CSV file again.

    Regards,
    Tobias

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

The topic ‘Support for large tables?’ is closed to new replies.