[metrics-bugs] #27356 [Metrics/ExoneraTor]: Reduce database size and variance of query response times

[Tor Bug Tracker & Wiki]

#27356: Reduce database size and variance of query response times
--------------------------------+------------------------------
 Reporter:  karsten             |          Owner:  metrics-team
     Type:  enhancement         |         Status:  merge_ready
 Priority:  High                |      Milestone:
Component:  Metrics/ExoneraTor  |        Version:
 Severity:  Normal              |     Resolution:
 Keywords:                      |  Actual Points:
Parent ID:                      |         Points:
 Reviewer:  irl                 |        Sponsor:
--------------------------------+------------------------------

Comment (by irl):

 Replying to [comment:13 karsten]:
 > Do they also have an automatically combined version with all changes
 under source control, or do they otherwise explain how to obtain the
 latest schema? If this is obvious for their contributors, maybe it's also
 obvious for our future contributors.

 Well, you can run all the upgrade scripts in sequence without running the
 importer and then export the result. I don't think they have an annotated
 SQL file, but separate documentation.

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/27356#comment:14>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online