Add subj_uri_id and subj_origin_id columns to event_view
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Zeitgeist Framework |
Fix Released
|
Wishlist
|
Markus Korn |
Bug Description
If we add subj_uri_id and subj_origin_id columns to the event_view we could make the prefix searches about 10% faster. Combined with the upcoming optimization of the GLOB statement it will be possible to reduce the avg. time for this kind of queries from ~0.20s to ~0.12s.
As always I've added a script where you can test the proposed change to event_view yourself.
*** 551 entries starting with 'http://
SELECT DISTINCT id FROM event_view WHERE (timestamp >= ? AND timestamp <= ? AND ((subj_uri IN (SELECT value FROM uri WHERE value GLOB ?)))) ORDER BY timestamp DESC [u'0', u'9223372036854
---> get len(ids)=551 using pure sql in 0.206047s
SELECT DISTINCT id FROM event_view_new WHERE (timestamp >= ? AND timestamp <= ? AND ((subj_uri_id IN (SELECT id FROM uri WHERE value GLOB ?)))) ORDER BY timestamp DESC [u'0', u'9223372036854
---> get len(ids)=551 using pure sql in 0.179763s
Related branches
- Siegfried Gevatter: Approve
-
Diff: 66 lines (+12/-16)2 files modified_zeitgeist/engine/sql.py (+10/-14)
test/sql-test.py (+2/-2)
Changed in zeitgeist: | |
importance: | Undecided → Wishlist |
assignee: | nobody → Markus Korn (thekorn) |
assignee: | Markus Korn (thekorn) → nobody |
Changed in zeitgeist: | |
assignee: | nobody → Markus Korn (thekorn) |
status: | New → In Progress |
Changed in zeitgeist: | |
status: | In Progress → Fix Committed |
Changed in zeitgeist: | |
milestone: | none → 0.6 |
Changed in zeitgeist: | |
status: | Fix Committed → Fix Released |