Okay
  Public Ticket #2981155
WPDataTables Table loads very slowly
Closed

Comments

  • Gregory S Carter started the conversation

    Hello: We posted our issue with wpDataTables on your FaceBook page where your social media manager asked us to submit a ticket. We can circle back with them.

    We purchased wpData Tables recently. The page URL is https://bcsswitchgear.com/manufacturer-documentation/.

    The table loads extremely slowly. We've tested this on multiple PCs and different browsers with the same result.

    We would like to get this resolved as we manage many WordPress sites and like the functionality of your product. We could use wpDataTables there as well.

    Thank you.

  •  1,851
    Miloš replied

    Hi, Gregory

    - Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    - We noticed a couple of errors in the console, for example, this error 400 as a bad Admin-Ajax response:

    8025543193.png


    These errors can happen for a few reasons.

    Check if you have any errors, notices, warnings in your console. If there are, resolve them first because they are interrupting wpDataTables' admin-ajax calls and the errors returned are referring to either bad Ajax or bad JSON response.

    Another thing that could be causing this is cache. If the data is being cached on the page, the returned data is not the same, or not at least what wpDataTables is expecting to see, so the error occurs. Try clearing all cache from your website and browser, and then prevent the pages containing wpDataTables from being cached.

    Last, it could be the data in the table(s) - if the data is not the type that it should be (for example, a non-numerical value in an integer or a float column), or if the data has been changed for a formula column. Try creating a new table from the source table and see if it's going to cause errors. If it doesn't (after excluding cache as the cause), look for differences between data, filters, etc.

    -

    - Also, if you solve the console errors, wanted to additionally advise for the loading speed.

    We noticed that this table is JSON-based, and seems like you have more than 3 thousand rows in it.

    If your data set is quite large (many thousands of rows), using the JSON format for creating a wpDataTable would not be a good solution, since the page generation time and size would significantly increase. MySQL-based wpDataTables with server-side processing is always the best option for large datasets.

    - Please contact us further if you tried all mentioned above, and we will do the best we can to assist.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables