abhishekkumaresan opened a new issue #11048:
URL: https://github.com/apache/incubator-superset/issues/11048
HI,
I am using superset for the dashboard, My data resides in Mysql, There
are about 15 Million records for 2 years and growing at a rate of 70,000
(approx.) records per day, I have a 5 tabbed dashboard with 41 Charts, I have
aggregated the data which I could aggregate but for other charts, The data is
in its normal form and we have to give the users the ability to change time
grail. Can anyone give me suggestions on the right database to use?
The time taken to display the hourly average for a single day is fine (5-6
seconds per chart after Indexing and partitioning in Mysql) (which is the
default), But the time taken for the
"Last Week" is 52 seconds
"Last Month" is 1 minute and 14 Seconds
"Last Quater" filter is about 3 minutes and 40 seconds
Will databases like Druid work for this case or should I try to aggregate
the data more.
Note:- I am not sure if this is the right place to ask this question.
Thank you.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
