Queries for subj_uri and subj_origin are using no index
Bug #673394 reported by
Markus Korn
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Zeitgeist Framework |
Fix Released
|
Undecided
|
Markus Korn |
Bug Description
We have a bunch of queries which are using no index and therefor are much slower than others, this is one example:
Running: engine.
DEBUG:zeitgeist
QUERY:
SELECT DISTINCT id FROM event_view GROUP BY subj_uri ORDER BY timestamp DESC LIMIT 6 ([])
PLAN:
[0, 0, u'TABLE event']
[0, 0, u'TABLE uri USING PRIMARY KEY']
DEBUG:zeitgeist
---> MostRecentSubjects: get len(ids)=6 using .find_eventids() in 0.571749s
All quries with subj_uri and subj_origin are affected.
Related branches
lp:~thekorn/zeitgeist/db_schema_3
- Siegfried Gevatter: Approve
- Seif Lotfy: Approve
- Mikkel Kamstrup Erlandsen: Pending requested
-
Diff: 123 lines (+32/-16)5 files modified_zeitgeist/engine/__init__.py (+1/-1)
_zeitgeist/engine/main.py (+9/-5)
_zeitgeist/engine/sql.py (+9/-8)
_zeitgeist/engine/upgrades/core_2_3.py (+11/-0)
test/sql-test.py (+2/-2)
Changed in zeitgeist: | |
status: | New → Confirmed |
Changed in zeitgeist: | |
status: | Confirmed → In Progress |
assignee: | nobody → Markus Korn (thekorn) |
Changed in zeitgeist: | |
milestone: | none → 0.7.0 |
Changed in zeitgeist: | |
status: | In Progress → Fix Committed |
Changed in zeitgeist: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.