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!