← Back to team overview

zeitgeist team mailing list archive

Re: [Bug 583065] Re: slow querying

 

No no no i am just showing the Zeitgeist part :)
i am printing the zeitgeist time not tracker time.

On Thu, May 20, 2010 at 8:40 AM, Mikkel Kamstrup Erlandsen <
mikkel.kamstrup@xxxxxxxxx> wrote:

> I really don't think this classifies as a valid bug report if I
> understand what you are saying correctly..? You complain that round
> tripping  Client -> Tracker - > Client -> Zeitgeist -> Client is slow?
>
> I think we can only care about the speed of pure Client <-> Zeitgeist
> interactions. Can you post a simple Python script that illustrates the
> problems in a purely ZG related scope? Or at the very least you need to
> profile each of these interactions so we can have an idea where the
> "bug" is...
>
> --
> slow querying
> https://bugs.launchpad.net/bugs/583065
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> 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
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/zeitgeist/+bug/583065/+subscribe
>
>


-- 
This is me doing some advertisement for my blog http://seilo.geekyogre.com

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





References