[tor-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:  needs_review
 Priority:  Medium              |      Milestone:
Component:  Metrics/ExoneraTor  |        Version:
 Severity:  Normal              |     Resolution:
 Keywords:                      |  Actual Points:
Parent ID:                      |         Points:
 Reviewer:                      |        Sponsor:
--------------------------------+------------------------------

Comment (by karsten):

 Update: Putting in an SSD reduced the runtime for that initial query from
 1 day 20 hours to 1 hour! Migration finished over night in only 10 hours
 total! I'm now importing the past three weeks of data to catch up. If all
 goes well, I'd like to upload this database to the server rather than do
 the migration there again.

 As part of testing, I pushed
 [https://gitweb.torproject.org/user/karsten/exonerator.git/commit/?h=task-27356&id=25ea8a886444e7851ecbc33233a269a458d48ea8
 25ea8a8] with a small but important fix to my branch.

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