Data table load takes too long

  • Resolved kaisainen

    (@kaisainen)


    3 years, 2 months ago

    We’ve recently began using WP Data Access but have run into an issue with creating a Data Table for the front-end. Our data model contains three tables with either many-to-many relationships or one-to-many relationships. I created an SQL view that combines data from these tables in order to create the Data Table. There only a few hundred rows so we’re not talking about a huge amount of data.

    Not sure why, but the front-end table takes a long time to load (even 14 seconds which is really inconvenient) – the reason is a post request from admin-ajax.php. I’ve noticed that also some of WP Data Access demo tables take some time to load. I’ve tried switching from server-side to client-side processing, indexing, removing dynamic links and caching but nothing has really made any effect. Do you have some suggestions on what we could look into to speed up the table load time? Would really appreciate any advice and help!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter kaisainen

    (@kaisainen)

    3 years, 2 months ago

    Actually, this is resolved now. You can close this.

    Plugin Contributor Kim L

    (@kimmyx)

    3 years, 2 months ago

    Hi @kaisainen,

    Thank you for the quick update!

    We’d love to know how you managed to resolve it if you’re alright with sharing.

    We’ll now mark this as resolved. 🙏

    Thread Starter kaisainen

    (@kaisainen)

    3 years, 2 months ago

    Somehow re-installing WordPress and updating everything helped even though everything was installed and updated just a month ago. Not sure what was causing those long admin-ajax.php requests previously so just a bit worried if they reappear later on. But, if you’ve run into them and know what’s happening there, please share!

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

The topic ‘Data table load takes too long’ is closed to new replies.