unresponsive page while large table loads

  • Resolved rlohmj

    (@rlohmj)


    3 years ago

    Hi @tobiasbg,

    I need to display on the front-end a new table with 7,000+ rows and at least 4 columns that contain information about places and the respective countries they are in.

    I had another table that contains 1,000+ rows that I have heavily styled with your plugin that works decently fast and reassures users that the page is loading with your help in “loading notification while table is made hidden when loading?” support thread.

    However, the large jump from about 4,000 cells to 28,000 cells is making load times much longer and the page is temporarily unresponsive during this loading process.

    I found this while reading more on DataTables which you have used: Q. DataTables is running slow. How can I speed it up?

    I am not sure which method you used in your plugin, DOM / AJAX / PHP, so I wanted to know if that FAQ can help speed up load speeds.

    Side-track:
    I also found this support thread I found interesting since I am making use of “WP Data Access” and “Code Manager” to make some of my page contents dynamic with SQL queries: “https://www.ads-software.com/support/topic/connection-to-a-sql-database/”

    I know how to make the HTML table with PHP, but how do I

    then use the external DataTables JavaScript library from https://datatables.net/ to add the features to that table

    ? However this method still does not help me speed up the table loading process right?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    TablePress currently only supports the “DOM” method for loading table data on the frontend, so that’s essentially where the limitations are coming from.
    However, I’m already working on making server-side processing possible, which will come with TablePress 2.0, probably in the second quarter of the year.

    Your “side-track” does not apply to TablePress, as it does not directly use SQL database queries. You would have to do that with custom PHP code and then render the table HTML. For integrating DataTables, I recommend https://datatables.net/manual/installation . You will need additional code in a custom plugin or in your theme files for this.

    Regards,
    Tobias

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    and here it is, the first beta of TablePress 2.0 is ready for testing, if you are still experiencing this performance issue: https://tablepress.org/8-million-downloads-tablepress-2-0/

    Best wishes,
    Tobias

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘unresponsive page while large table loads’ is closed to new replies.