[tor-bugs] #17488 [ExoneraTor]: ExoneraTor hangs forever on old known-positive test

[Tor Bug Tracker & Wiki]

#17488: ExoneraTor hangs forever on old known-positive test
------------------------+--------------------------
 Reporter:  starlight   |          Owner:  karsten
     Type:  defect      |         Status:  accepted
 Priority:  Very High   |      Milestone:
Component:  ExoneraTor  |        Version:
 Severity:  Major       |     Resolution:
 Keywords:              |  Actual Points:
Parent ID:              |         Points:
  Sponsor:              |
------------------------+--------------------------

Comment (by starlight):

 it did cut the time in half

 maybe the other AND clauses are having
 some similar sort of impact?  causing
 the DB engine to to build full lists
 before starting the evaluation?

 can it be simplified or broken into
 more than one step to prevent mysql
 from sub-optimizing?  any way to
 add processing hints?  (I'm not
 a SQL expert)  Or maybe trim the
 set from the JOIN in memory after
 retrieval instead of using the
 WHERE clause?

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