Skip to content
This repository was archived by the owner on Jul 22, 2024. It is now read-only.

Research: On-the-fly averaging, by week only #41

Open
ecumike opened this issue Nov 9, 2018 · 1 comment
Open

Research: On-the-fly averaging, by week only #41

ecumike opened this issue Nov 9, 2018 · 1 comment
Labels
perf An update to improve the app performance research needed

Comments

@ecumike
Copy link
Contributor

ecumike commented Nov 9, 2018

Investigate and test "pick a week" report detail page scoping for the two averages tables; KPI and user-timing.

Allowing "week of ___" data scoping may be performant enough to do on-the-fly because it's only grabbing 7 runs and averaging them.

Test how bad the query would be to do on-the-fly date range scoping averaging of a URL's runs with a database of at least 7,000 URL records, each with 60 runs (two months of test runs data).

@daviddahl
Copy link
Contributor

sure, and we can cache weeks too - say every sunday or whatnot, write the week's average to the database

@ecumike ecumike added research needed perf An update to improve the app performance labels Nov 9, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
perf An update to improve the app performance research needed
Projects
None yet
Development

No branches or pull requests

2 participants