[tor-bugs] #15844 [Onionoo]: Develop database schema to support Onionoo's search parameter efficiently

[Tor Bug Tracker & Wiki]

#15844: Develop database schema to support Onionoo's search parameter efficiently
-----------------------------+-----------------
     Reporter:  karsten      |      Owner:
         Type:  enhancement  |     Status:  new
     Priority:  normal       |  Milestone:
    Component:  Onionoo      |    Version:
   Resolution:               |   Keywords:
Actual Points:               |  Parent ID:
       Points:               |
-----------------------------+-----------------

Comment (by teor):

 Some suggestions:
 * normalised columns (one column per data item), even if you denormalise
 the table,
 * indexes on each column you want to search by the start (and/or perhaps
 on common column combinations),
 * collations on the case-sensitive/insensitive columns, and
 * wildcard LIKE %foo% searches are always slow, but the trigrams package
 you mention might help with that

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