[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:11 karsten]:
 > Without something like this, new contributors will have a hard time
 going through all scripts just to learn the current state of things.

 Observium has all the files in a directory with their version number and a
 script to run through them in sequence.

 Ah, also the version number of the schema should be in the database to
 allow you to know where you are and how much upgrading you need to do.
 Running the script twice should produce the same result as running it
 once.

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