← Back to team overview

zeitgeist team mailing list archive

[Bug 583065] Re: slow querying

 

I think we agreed that this is most likely not an issue with zeitgeist, we also changed test/scalability-test.py trying to reproduce exactly this scenario, but the timings provided there are much lower than the timings provided here.
We agreed that this is most likely an issue in sezen's gtk event handling loop.

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

-- 
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: Invalid

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





References