Comment 5 for bug 844877

And more research:

<mhr3> i just tried two queries in `sqlite3`
 SELECT subj_id FROM event_view WHERE subj_uri IN ('application://gedit.desktop', 'application://firefox.desktop', 'application://devhelp.desktop', 'application://google-chrome.desktop', 'application://dfeet.desktop', 'http://twitter.com/', 'file:///home/miso/projects/checkout/gnome/glib/glib/gquark.h', 'http://www.google.cz/search?sourceid=chrome&ie=UTF-8&q=youtube+darky+rom+10.2') GROUP BY subj_id;
<mhr3> and
 SELECT id FROM uri WHERE value IN ('application://gedit.desktop', 'application://firefox.desktop', 'application://devhelp.desktop', 'application://google-chrome.desktop', 'application://dfeet.desktop', 'http://twitter.com/', 'file:///home/miso/projects/checkout/gnome/glib/glib/gquark.h', 'http://www.google.cz/search?sourceid=chrome&ie=UTF-8&q=youtube+darky+rom+10.2');
<mhr3> the second one is much much much faster (also there's no visible difference between "... OR value = '...' OR ..." and "IN ('...', ...)")