Queries for subj_uri and subj_origin are using no index

Bug #673394 reported by Markus Korn on 2010-11-10
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) on 2010-11-10
Changed in zeitgeist:
status: New → Confirmed
Markus Korn (thekorn) on 2010-11-12
Changed in zeitgeist:
status: Confirmed → In Progress
assignee: nobody → Markus Korn (thekorn)
Seif Lotfy (seif) on 2010-11-16
Changed in zeitgeist:
milestone: none → 0.7.0
Markus Korn (thekorn) on 2010-11-16
Changed in zeitgeist:
status: In Progress → Fix Committed
Seif Lotfy (seif) on 2011-01-18
Changed in zeitgeist:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers