Queries for subj_uri and subj_origin are using no index

Bug #673394 reported by Markus Korn
6
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.find_eventids(TimeRange.always(), [], StorageState.Any, 6, ResultType.MostRecentSubjects)
DEBUG:zeitgeist.sql:Got query:
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.engine:Found 6 event IDs in 0.571514s
---> MostRecentSubjects: get len(ids)=6 using .find_eventids() in 0.571749s

All quries with subj_uri and subj_origin are affected.

Related branches

Seif Lotfy (seif)
Changed in zeitgeist:
status: New → Confirmed
Markus Korn (thekorn)
Changed in zeitgeist:
status: Confirmed → In Progress
assignee: nobody → Markus Korn (thekorn)
Seif Lotfy (seif)
Changed in zeitgeist:
milestone: none → 0.7.0
Markus Korn (thekorn)
Changed in zeitgeist:
status: In Progress → Fix Committed
Seif Lotfy (seif)
Changed in zeitgeist:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.