Table has over 30,000 rows – Loading time Crashes
-
Hello,
Love the TablePress and we support this plugin.
My question please, I just added another table and this table has 31,103 rows of data. When viewing the table, the loading time is super slow and crashes. Therefore, I cannot view all the contents within this table. Do you have a solution for this?
Thank you
By the way I will be following this youtube tutorial.
-
I read this form post and wanted to know if this is still in the works or if you have a solution now, thank you.
https://ww.wp.xz.cn/support/topic/tablepress-editor-with-many-entries/
When I added it through the Auto Imports Table, only 100 rows pulled in, instead of 31,103 rows.
Strange, do you know why all the data was not pulled in?
Thank you
Hi,
thanks for your post, and sorry for the trouble.
Yes, the mentioned completely rewritten “Edit” screen for higher speed and better performance is coming! And the good thing: You can already use and test it now! 🙂 Please see https://tablepress.org/8-million-downloads-tablepress-2-0/ for information on TablePress 2.0-beta1 which contains this.
As for the Auto Import: What is the Import Source that you are using? Does everything work correctly if you use the regular import for the same import source?
Regards,
TobiasHi Tobias,
I appreciate your patience with this. Thank you for providing the beta version. I will upload that today and test it out.
As for the Google Sheet link. To answer your question, yes, I upload the spreadsheet first and then that’s when I was having problems because it contains over 31,000 rows.
So, I thought if I use the import section and link to Google, maybe it would pull in faster. However, the full content did not pull in.
The import is only pulling in 100 rows and that is it. Here is the link
https://docs.google.com/spreadsheets/d/1zrGv–jF8kBx6l-Gry4dGqz1GoD87SBnyk627l0vAZg/edit?usp=sharingHere is the page https://livinghisword.org/study-the-bible-verse-by-verse/
Hi Tobias,
I have upgraded to the new beta version. Loving it! Do you intend to add a bit more to it, such as pagination on the backend and possible a search function on the backend table?
I will be more than happy to donate more to help your cause.
Please let me know.
Thank you
Here is a video of my experience
https://www.awesomescreenshot.com/video/10734278?key=bf3a3bab865783ea432348adcf0bb250Also, I noticed on the frontend it loads all the rows instead of the number listed on the pagination selection box option. Is there a way it only loads the number you suggested on;
“Enable pagination of the table (viewing only a certain number of rows at a time) by the visitor.
Show
10
rows per page.”Here I have chosen 10 to view at a time.
https://www.awesomescreenshot.com/video/10734976?key=5a06000902e11c0adcae65ed65e69ae8
Thank you 🙂
-
This reply was modified 3 years, 9 months ago by
nittygrittytechy.
Hi Tobias,
I found a bug 🙁
When I try to save the Import section it will not let me.
https://www.awesomescreenshot.com/video/10735128?key=39e99753ad942ab555867e29c8c216cd
One more thing, please
The dropdown for the show entries is siting on top of the search box. Do I need to css code this to fix it?
https://www.awesomescreenshot.com/image/31792962?key=bb184995ba23f1f28f71ec51470cda0e
-
This reply was modified 3 years, 9 months ago by
nittygrittytechy. Reason: added one more fix
Sorry, Tobias for all the messages, but I have one more question to ask.
Is there a way to pull in a post feed? Or add a post feed based on category and tags? I would like to add this feed only within the table https://livinghisword.org/category/biblicalnews/
Thank you for your time 🙂
JenniferHi Tobias, found another bug.
The problem I am having is I cannot add new content to a new row.
https://www.awesomescreenshot.com/video/10754639?key=10bf1b5244c1a5ccaa57725a17579bec
Thank you
JenniferP.S. I am going back to the other version, so I can continue using your table on my site.
Hi Jennifer,
thanks for all your feedback here! I hope that I don’t forget something in my replies:
For the 100 rows of the Auto Import: You are using the wrong URL here. This is the editing URL. You will first have to “publicly share” the table on Google Sheets and then use the modified URL like https://docs.google.com/spreadsheets/d/…/pub?output=csv
For TablePress 2.0:
– I’m experimenting with pagination on the “Edit” screen, but am not yet sure that it’s not causing more trouble than it brings advantages.
– For searching on the “Edit” screen, I will also check some options, but for now recommend the regular browser search that you are already using.As for the loading of all rows on the frontend: That’s correct, first all rows are loaded and then the pagination is applied. However, TablePress 2.0 will also have a premium version which will have “server-side processing” where really only the needed rows will be loaded. 🙂
The bug with the import not working: That’s due to an incompatibility of the old Auto Import Extension. It does not yet work with TablePress 2.0 🙁
For the spacing between the dropdown and the search: This can be fixed by adding this to the “Custom CSS” textarea on the “Plugin Options” screen of TablePress:
.dataTables_filter { margin-top: 6px; }Pulling in a post feed: No, sorry, something like that is not possible. A post feed is a complex XML format, which can not directly be imported as a table. Sorry.
And finally that bug with not being able to add content to a row: That’s something that I would really like to investigate! I have not yet seen that in my tests. If possible, I’d like to take a direct look at this on your site. Could you therefore please get in touch via email (the address is on https://tablepress.org/impressum/ )? That way, I can investigate this directly. Thanks!
Regards,
TobiasThank you, Tobias!
I look forward to your premium version coming. Do you have an eta. on that?
Thank you
JenniferHi Jennifer,
thanks for your email, will take a look asap!
As for the premium version: A few things still need some work, and I’m still waiting for some documents regarding founding a company and stuff like that, but it won’t take too long anymore 🙂 Likely September or early October.
Regards,
TobiasOooooo, I am super excited.
Looking forward to seeing the premium.
I had to revert to the original working TablePress because my site is live.
Let me know when you need access and I can add it back 🙂
Jennifer
Hi Jennifer,
cool! 🙂
I had replied to your email earlier today, did you receive that reply?
Regards,
TobiasYes, I will email you today, please look for it. 🙂
-
This reply was modified 3 years, 9 months ago by
The topic ‘Table has over 30,000 rows – Loading time Crashes’ is closed to new replies.