Large Dataset throwing Ajax Error

  • Resolved Adviata Ashrama

    (@advaitaashrama)


    3 years ago

    Namaste,

    We are currently using wp-data-access to show a list of articles in our journal. Recently we have switched from using table to using a view as it is more dynamic and low maintenance.

    However, on loading this article page with updated view we are getting Ajax error. Can you please help us in resolving this issue?

    You can see the error here: https://prabuddhabharataarchives.advaitaashrama.org/title-index/

    Here is the error message:
    DataTables warning: table id=T_articles2 – Ajax error. For more information about this error, please see http://datatables.net/tn/7

    Here are the advance settings of the published table:
    {
    “paging”: true,
    “pageLength” : 50,
    “stateSave”:false,
    “autoWidth”: false,
    “width” : 80,
    “wpda_use_estimates_only”: true,
    “serverSide”: true
    }

    Any help will be greatly appreciated.

    -Advaita Ashrama

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    3 years ago

    Hi @advaitaashrama,

    We checked the link but didn’t see any error when loading the table.

    Please see: https://share.getcloudapp.com/RBurkBNE

    From the error you pasted above, we are referred to this page: https://datatables.net/manual/tech-notes/7

    The above indicates issues related to the server, so it’s safe to assume that the error was temporary depending on the server’s response.

    Since we’re not seeing the error when we checked, we’re unable to debug it at the moment.

    If you ever see the error again, please follow the troubleshooting guide outlined on https://datatables.net/manual/tech-notes/7

    Hope this helps! Let us know if you have more questions.

    Thread Starter Adviata Ashrama

    (@advaitaashrama)

    3 years ago

    Namaste Kim,

    Sorry to bother you again.

    You’re right. The error doesn’t always show up but it does appear quite often. The dataset is sourced from a view having approx. 19000 rows.

    Unfortunately, I was not able to follow the troubleshooting guide but I am confident that the error is due to loading all rows at once.
    How can we reduce the server load ?
    Is there an option to load fewer rows in each request ?

    Can you please suggest any other solution along those lines ?

    Plugin Contributor Kim L

    (@kimmyx)

    3 years ago

    Hi @advaitaashrama,

    Thanks for the response. I see, the size of the table could be the main culprit.

    We have a few suggestions outlined for large tables and performance. Please see: Large tables & performance | WP Data Access

    Let us know if this helps!

    Leeberty

    (@aaronvincentlee)

    2 years, 12 months ago

    Due to inactivity, I’m closing this thread for now.
    Feel free to add a new reply to continue the conversion for this support request.

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

The topic ‘Large Dataset throwing Ajax Error’ is closed to new replies.

Tags