Hi. I am looking for advice regarding my scenario. I have a large amount of data in a single table (timeseries data) that I could obtain in 1 query. My table is set up as a date (for the time series) and then many many columns.
I have set up a single query then linked many graphs to this table. If I have 10 graphs using this table, in it's entirety (with, say all 11 columns), is it loaded only 1 time or 10 times (once for each graph)?
If it is 10 times, or once per graph, would I see faster load times by linking only the data I need for a graph into a data table and create 10 corresponding data tables instead of one?
If you actually have 10 charts (10 different shortcodes), you can load them all on the same page. The loading time will increase, though, as each chart is generated by an admin-ajax call, so each call takes some time.
Since they're coming from an SQL query based table, the speed would be the same if you use 10 different tables or just one. Maybe it's even better to use just this one table, because the amount of admin-ajax calls would be decreased.
Hi. I am looking for advice regarding my scenario. I have a large amount of data in a single table (timeseries data) that I could obtain in 1 query. My table is set up as a date (for the time series) and then many many columns.
I have set up a single query then linked many graphs to this table. If I have 10 graphs using this table, in it's entirety (with, say all 11 columns), is it loaded only 1 time or 10 times (once for each graph)?
If it is 10 times, or once per graph, would I see faster load times by linking only the data I need for a graph into a data table and create 10 corresponding data tables instead of one?
Hello Andrew
If you actually have 10 charts (10 different shortcodes), you can load them all on the same page. The loading time will increase, though, as each chart is generated by an admin-ajax call, so each call takes some time.
Since they're coming from an SQL query based table, the speed would be the same if you use 10 different tables or just one. Maybe it's even better to use just this one table, because the amount of admin-ajax calls would be decreased.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
Thank you Aleksander, this is helpful. I will continue to use just one table and link multiple charts to it in order to minimize load time.
You're welcome Andrew
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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