zeitgeist team mailing list archive

[Seif Lotfy <seif@xxxxxxxxx>]

Public bug reported:

My DB has exactly 416 subjects

*** events: 416      time:  0.541239023209
*** events: 1      time:  0.0319149494171               # querying mostused events where subject.uri is a specific uri
*** events: 2      time:  0.499359130859                 # querying mostused events where subject.uri is one of 2 specific uris
*** events: 30      time:  10.8581418991                 # querying mostused events where subject.uri is one of 30 specific uris
--------------------------------------------

I duplicated the queries again...

*** events: 416      time:  0.487861871719
*** events: 1      time:  0.0361568927765
*** events: 2      time:  0.499109983444
*** events: 30      time:  16.0003550053

What is happening in the background is that i query tracker for a string
i get all matching uris and then query Zeitgeist

you can test with lp:~seif/sezen/sezen2/
You will need ZG trunk to test it

** Affects: zeitgeist
     Importance: High
         Status: Confirmed

** Changed in: zeitgeist
   Importance: Undecided => High

** Changed in: zeitgeist
       Status: New => Confirmed

** Changed in: zeitgeist
    Milestone: None => 0.3.4

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

Status in Zeitgeist Framework: Confirmed

Bug description:
My DB has exactly 416 subjects

*** events: 416      time:  0.541239023209
*** events: 1      time:  0.0319149494171               # querying mostused events where subject.uri is a specific uri
*** events: 2      time:  0.499359130859                 # querying mostused events where subject.uri is one of 2 specific uris
*** events: 30      time:  10.8581418991                 # querying mostused events where subject.uri is one of 30 specific uris
--------------------------------------------

I duplicated the queries again...

*** events: 416      time:  0.487861871719
*** events: 1      time:  0.0361568927765
*** events: 2      time:  0.499109983444
*** events: 30      time:  16.0003550053

What is happening in the background is that i query tracker for a string i get all matching uris and then query Zeitgeist

you can test with lp:~seif/sezen/sezen2/
You will need ZG trunk to test it