[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 karsten):

 Replying to [comment:12 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.

 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.

 > 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.

 Good idea. I'll add such a version table and checks to the existing two
 scripts.

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