Timeline for Calculating duration between two events in a MySQL database (timeseries)
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 12, 2018 at 4:17 | comment | added | Akina | @iPathツ 2-days period == how many records? how many output records? and how many different FeedId values? PS. I think the solution with user variables usage maybe more fast... | |
| Jul 12, 2018 at 4:15 | comment | added | Akina |
@iPathツ CREATE INDEX idx ON feedsdata (value, FeedId, `DateTime`) optimizes the subquery. Outer query can not be optimized by index build.
|
|
| Jul 11, 2018 at 18:13 | comment | added | iPath ツ | Very clever solution! Unfortunately it takes about 2 minutes to compute the duration for 2 days period. Can you suggest some optimization in terms of indexes? | |
| Jul 11, 2018 at 5:48 | history | answered | Akina | CC BY-SA 4.0 |