Size of table

Hi Alex – I’m not Tobias so he may have more accurate information.

I run the Hymn Society of Great Britain and Ireland website. We use TablePress for a number of tables, the biggest page is our interactive index of Bulletins which has over 16,000 rows split into 7 tables, currently the largest single table is just over 7,700 rows. The page: https://hymnsocietygbi.org.uk/resources/interactive-bulletin-indexes/
takes a few seconds to load, but this is just the browser getting the data. Once the data is there the tables work really fast.

Kind regards,

Ken

Hi,

thanks for your question!

Yes, Ken’s numbers (thanks for sharing them) sound reasonable. This is what I’ve seen with other users as well. Results will vary of course, depending on the actual size and content in the table.

Note that there’s an extra place that however will cause trouble with large tables like this: The “Edit” screen of the table will likely be very slow or even unusable. In that case, I recommend to maintain and edit the table in e.g. Excel and then re-import it as a CSV file into TablePress after making changes.

Regards,
Tobias

Yes, I forgot about times for the edit.

The table with over 7,700 rows takes about a minute to load and, in Chrome, when trying to edit the rows Chrome becomes unusable whereas Firefox does a better job but it still does take time. As I’m only editing a few rows at a time – adding hyperlinks in one column – it’s something I can work with, but, when adding rows to the table I prepare the extra rows in Excel and import the data, appending to the table.

Kind regards,

Ken

Hi,

indeed, trying different browsers here is always good! As the respective JavaScript engines differ (but get better over time), the browsers should different results on the “Edit” screen as well.

Regards,
Tobias

Hi both

Thanks for your input
I am looking at the Baptism records for our church. There are 11,000 of them (over a period of 200 years). Once loaded they wont need to be updated. I guess I could load them into tables based on the century (1600’s, 1700,s etc) and there would only be 8 fields.

Alex

Hi Alex,

yes, that could work. As you probably already have the data in some tabular format (like an Excel file), I recommend to just try it ??

Regards,
Tobias