I have created about 30 datatables to display on our website all using sql queries. I have them all linked to a dashboard page where I am using the column sum shortcode to display the metric to click to obtain the report. The problem is that the page takes a very long time to load as it appears to be fetching all data for all 30 reports in order to display the metrics. Any ideas on how this can be done with improved speed?
Here is an example of the shortcodes I am using on the dashboard page: [wpdatatable_sum table_id=7 col_id=57]
I have tried installing a few different cacheing plugins but it has not helped.
Sorry I didn't quite understand your request. It would be really helpful if you could explain it in little more details (possible screenshoot/screencast). By report do you refer to tables or to reports from Report builder add-on
Please also open a ticket with answer in corresponding section of this support and one of our support managers will do their best to help you with issue. This section is dedicated to pre-purchase questions. Thank you for understanding.
Hello,
I have created about 30 datatables to display on our website all using sql queries. I have them all linked to a dashboard page where I am using the column sum shortcode to display the metric to click to obtain the report. The problem is that the page takes a very long time to load as it appears to be fetching all data for all 30 reports in order to display the metrics. Any ideas on how this can be done with improved speed?
Here is an example of the shortcodes I am using on the dashboard page:
[wpdatatable_sum table_id=7 col_id=57]
I have tried installing a few different cacheing plugins but it has not helped.
Thanks,
Rob
Hi Rob,
Thank you for your inquire.
Sorry I didn't quite understand your request. It would be really helpful if you could explain it in little more details (possible screenshoot/screencast). By report do you refer to tables or to reports from Report builder add-on
Please also open a ticket with answer in corresponding section of this support and one of our support managers will do their best to help you with issue. This section is dedicated to pre-purchase questions. Thank you for understanding.