Happy Monday everybody - I have a question regarding optimizing the load time of pages in the "Dashboards" view. We are running phoenix on AWS using EC2 and RDS and have about 200G of data. We've upsized our RDS instance, but I was curious if there were any tricks for optimizing this view or work happening in this area I can test out?
馃挕聽Hint: Mention RunLLM in the thread for followups.
We are running version 16.2.0.
thanks, i'll explore using a read-replica although I did not observe much db contention cpu or IOPS wise at a steady state. regarding #2 - several of the dashboard items will timeout. in general it takes over 60seconds to load, and page reloads seems to exhibit the same behavior which makes me suspect things aren't being cached? regarding timeframe - in particular we are interested in trends of data usage week-over-week. Additionally we have a 30day retention policy but we would like to expand that in the future.
One successful workaround i've seen for these expensive reporting queries is the option to download a CSV report.
