Slow Table when using more than 300 rows

Hi,

thanks for your post, and sorry for the trouble.

I see what you mean, but unfortunately, lazy-loading is not yet possible for TablePress. I do have some ideas for this, but it’s not easy to implement, unfortunately.

Also, can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!

Regards,
Tobias

Thanks for your reply!

Is there a other solution to speed up the page with a large table?

I would like to sent the URL, but I do not want to post the URL in this topic.
Can I send it to you in person?

Hi,

that’s difficult to say, I’m afraid. We’d first need to find out what’s causing the slowness.

Yes, please send me the URL via email then, the address is in the main plugin file “tablepress.php”.

Regards,
Tobias

Hi,

thanks for the link! Now, I tested it on my machine, but don’t really experience slowness, to be honest… The perceived speed is quite fast and similar to other pages that don’t have tables…
So, I’m not sure what we can do here :-/

Regards,
Tobias

Hi,

Thanks for your reply!

Will the “lazy load” option something, you will be adding in the near future?

Hi,

I’m not sure yet, to be honest. I do have some ideas for this, and there are interesting approaches for in the DataTables JS library, but I’ll have to run more tests first, to find out how I can implement this efficiently.

Regards,
Tobias

Hi,

Ok, good to know.

Do you support a load more button? So that the table will only load the first 20 for example and than there is a load more button?

• This reply was modified 8 years, 2 months ago by henkzuurbier.

Hi,

depending on how exactly that solution will look like, a “Load more” button might be possible then, yes. Right now, this is not directly possible. I can only suggest a work around where you maybe create a second page with the large table, and the main page only gets the short/reduced table, together with a link to the page with the large table.

Regards,
Tobias

Hi,

I have the same problem with big table files, the table press admin area gets extremely slow and I can’t edit the table.

Is there any other way to import bigfiles?

Hi,

the only way here is to maintain the table e.g. in Excel and then re-import a CSV file into TablePress, choosing to replace the existing version. This way, you can avoid using the “Edit” screen for large tables.

Regards,
Tobias

hi,

That’s a good alternative but I need to choose the settings of the table, for example uncheck the option “Show information of table”, change the “number of rows to show”, etc.

Hi,

the trick there is to change the on a new created table (that is small) and then only then to import the actual data from the file.

If you need to change the settings of an existing (large) table, the best approach is to delete that table, create a new (small) one, change the settings, and change the table ID to the old one, and then import the data again.

Regards,
Tobias

Thanks TobiasBg it worked, now I have to figure out how to reduce the time of load of the post where the big table is published.

Hi,

that will be tricky. Depending on whether you are using the JavaScript functions, this might also add to the load time.

Regards,
Tobias

Hi @tobiasbg.

I am experiencing a similar situation, however, I have a table with just over 9,000 rows. (I understand this is giant. I am working on pruning duplicate entries).

Do you have any suggestions on how to speed up the load time. I’ve noticed that on the first load, it doesn’t paginate, just loads the whole table then adjusts itself. (Is that what lazy-loading is for?)

I’d love any suggestions, and I can give you the URL if you’d like.

Thanks!