Really big table in TablePress – ajax?

  • Resolved rgrigonis

    (@rgrigonis)


    9 years, 10 months ago

    I’m planning on doing a site with a really big table (thousands of rows). Normally, that would consume a lot of bandwidth at each user hits the site and downloads the table prior to the Javascript routines starting up. In the original datatables documentation, it says,

    “There are many ways to get your data into DataTables, and if you are working with seriously large databases, you might want to consider using the server-side options that DataTables provides. With server-side processing enabled, all paging, searching, ordering actions that DataTables performs are handed off to a server where an SQL engine (or similar) can perform these actions on the large data set (after all, that’s what the database engine is designed for!). As such, each draw of the table will result in a new Ajax request being made to get the required data. Server-side processing is enabled by setting the serverSide option to true and providing an Ajax data source through the ajax option.”

    Does TablePress allow for the usage of such large tables in an efficient manner?

    https://wordpress.org/plugins/tablepress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    9 years, 10 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    Unfortunately, I’ll have to disappoint you here. TablePress does not support this server-side loading that DataTables offers 🙁 I might be able to add it in the future, but I can’t promise it.

    Regards,
    Tobias

    sinclair_lewis

    (@sinclair_lewis)

    8 years, 12 months ago

    Do you have any tips for customizing Tablepress to allow server-side processing? datatables.net/manual/server-side makes it seem simple.

    For instance, if it just won’t work with Tablepress, that would be great to know.

    Many thanks for all your years of help, Tobias.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 12 months ago

    Hi,

    at the moment, this will indeed not really be possible, simply because there is now AJAX endpoint that can be used for such requests.
    Using the PHP files that DataTables provides, and a mySQL table, should be the better solution for server-side loading at this time.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Really big table in TablePress – ajax?’ is closed to new replies.