zeitgeist team mailing list archive

[Markus Korn <thekorn@xxxxxx>]

** Changed in: zeitgeist/0.7
       Status: In Progress => Fix Committed

-- 
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
https://bugs.launchpad.net/bugs/672965

Title:
  find_event() queries with timerange other than TimeRange.always() are
  slow

Status in Zeitgeist Framework:
  Fix Committed
Status in Zeitgeist Framework 0.7 series:
  Fix Committed

Bug description:
  When running the attached script you can see that when giving a
  timerange which does not start at 0 and end at maxint the queries get
  300% slower.

  python sample_timerange_query.py
  DEBUG:zeitgeist.sql:Got query:
  QUERY:
  SELECT DISTINCT id FROM event_view GROUP BY actor ORDER BY COUNT(actor) DESC, timestamp DESC LIMIT 6 ([])
  PLAN:
  [0, 0, u'TABLE event WITH INDEX event_actor ORDER BY']

  DEBUG:zeitgeist.engine:Found 6 event IDs in 0.080176s
  ---> MostPopularActor: get len(ids)=6 using .find_eventids() in 0.080375s
  DEBUG:zeitgeist.sql:Got query:
  QUERY:
  SELECT DISTINCT id FROM event_view WHERE (timestamp >= ? AND timestamp <= ?) GROUP BY actor ORDER BY COUNT(actor) DESC, timestamp DESC LIMIT 6 ([u'1', u'50000'])
  PLAN:
  [0, 0, u'TABLE event WITH INDEX event_timestamp']

  DEBUG:zeitgeist.engine:Found 6 event IDs in 0.260648s
  ---> MostPopularActor: get len(ids)=6 using .find_eventids() in 0.260838s

  The reason is simply that the second query uses the 'wrong' index.