I am trying to maintain a live graph based data pulled using sql queries. At the same time, I would like to maintain a table with the information the graph is based on right below it. Ideally, I am trying to keep the table sortable and filterable
I have the following issues:
I am not sure how to initially display a plot that gets overwritten right after by a newly generated one from a callback that used dcc.Interval.
The dataset is very large and the sql query takes about 12 seconds. I want to update both the plot and the table at the same time but my program runs quite slowly.
May I please have any suggestions on how to tackle these issues? Is there any way to display just the top of my table (based on the chosen sorting) while the rest is not loaded, for time efficiency?
What other performance efficiencies would I be able to add?
Thank you in advance for any help.