Okay
  Public Ticket #3373598
Very slow loading tables
Closed

Comments

  • Jon Siswick-Clark started the conversation

    I have less than 5k rows in my table, but it takes a really long time to load(15 seconds), is there anything that can be done to make it load faster, as it looks like there is an issue to the end user right now :( 
    FYI; I am using a Googlesheet! 

  •  1,848
    Miloš replied

    Hi, Jon.

    Something from your site or hosting server seems to be blocking a number of these image thumbnails that are trying to load from the Google Sheet table.

    For example, one of the XML files/thubmnails that has the 403 ( forbidden) error is this one :

    https://yakyik001.s3.amazonaws.com/corals/NemosReef/thumbail/ovdpk49qta605gci

    7589387413.png

    -

    If i try to open this path in a browser, it says the access is forbidden.

    And this is in the Browser Developer Console of your page with the table, there is a constant try to load these files, while something from the site or hosting server keeps blocking it with error 403.

    1278227892.png
    8004716616.png

    6025171135.png

    -

    I tried to disable all your other plugins, and just left wpDataTables, but still the same issue.

    Which means that you probably have some permission issues coming from the hosting server.

    Look at the back-end of this table and open the browser developer console ( For Chrome and Mozilla the hotkey is F12), and you will see these errors 403 :

    1657940217.png

    Please reach out to your hosting support, show them these screenshots and ask them to find what is blocking these files from loading.

    Let us know how it goes.

    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

  • Jon Siswick-Clark replied

    Yes, it was because the data needs to be updated on a daily basis, I updated today and did a quick check and there were no 403 errors, but the site still took ages to load :(
    Is there a faster way to do this instead of via googlesheet?

  •   Miloš replied privately