• Resolved nittygrittytechy

    (@nittygrittytechy)


    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.

Viewing 15 replies - 1 through 15 (of 18 total)
  • Thread Starter nittygrittytechy

    (@nittygrittytechy)

    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/

    Thread Starter nittygrittytechy

    (@nittygrittytechy)

    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

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    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,
    Tobias

    Thread Starter nittygrittytechy

    (@nittygrittytechy)

    Hi 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=sharing

    Here is the page https://livinghisword.org/study-the-bible-verse-by-verse/

    Thread Starter nittygrittytechy

    (@nittygrittytechy)

    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=bf3a3bab865783ea432348adcf0bb250

    Thread Starter nittygrittytechy

    (@nittygrittytechy)

    Also, 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 🙂

    Thread Starter nittygrittytechy

    (@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
    Thread Starter nittygrittytechy

    (@nittygrittytechy)

    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 🙂
    Jennifer

    Thread Starter nittygrittytechy

    (@nittygrittytechy)

    Hi 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
    Jennifer

    P.S. I am going back to the other version, so I can continue using your table on my site.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    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,
    Tobias

    Thread Starter nittygrittytechy

    (@nittygrittytechy)

    Thank you, Tobias!

    I look forward to your premium version coming. Do you have an eta. on that?

    Thank you
    Jennifer

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi 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,
    Tobias

    Thread Starter nittygrittytechy

    (@nittygrittytechy)

    Oooooo, 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

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi Jennifer,

    cool! 🙂

    I had replied to your email earlier today, did you receive that reply?

    Regards,
    Tobias

    Thread Starter nittygrittytechy

    (@nittygrittytechy)

    Yes, I will email you today, please look for it. 🙂

Viewing 15 replies - 1 through 15 (of 18 total)

The topic ‘Table has over 30,000 rows – Loading time Crashes’ is closed to new replies.