[Gnome-zeitgeist] [Merge] lp:~cando/gnome-activity-journal/audio_preview into lp:gnome-activity-journal

2010-11-09 Thread Seif Lotfy
The proposal to merge lp:~cando/gnome-activity-journal/audio_preview into lp:gnome-activity-journal has been updated. Status: Needs review = Merged -- https://code.launchpad.net/~cando/gnome-activity-journal/audio_preview/+merge/40342 Your team GNOME Zeitgeist Team is requested to review

[Gnome-zeitgeist] [Merge] lp:~cando/gnome-activity-journal/drag_and_drop into lp:gnome-activity-journal

2010-11-09 Thread noreply
The proposal to merge lp:~cando/gnome-activity-journal/drag_and_drop into lp:gnome-activity-journal has been updated. Status: Needs review = Merged -- https://code.launchpad.net/~cando/gnome-activity-journal/drag_and_drop/+merge/40277 Your team GNOME Zeitgeist Team is requested to review

[Zeitgeist] [Bug 672965] [NEW] find_event() queries with timerange other than TimeRange.always() are slow

2010-11-09 Thread Markus Korn
Public bug reported: 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 400% slower. python sample_timerange_query.py DEBUG:zeitgeist.sql:Got query: QUERY: SELECT DISTINCT id FROM event_view GROUP BY actor ORDER

[Zeitgeist] [Bug 632363] Re: Slow queries: SQL indexes not used

2010-11-09 Thread Markus Korn
I've just filed bug 672965 for one class of slow queries -- Slow queries: SQL indexes not used https://bugs.launchpad.net/bugs/632363 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. Status in Zeitgeist

[Zeitgeist] [Bug 672965] Re: find_event() queries with timerange other than TimeRange.always() are slow

2010-11-09 Thread Markus Korn
** Description changed: 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 - 400% slower. - + 300% slower. python sample_timerange_query.py DEBUG:zeitgeist.sql:Got query: QUERY: SELECT DISTINCT id

[Zeitgeist] [Merge] lp:~thekorn/zeitgeist/fix-672965-opt_timerange_queries into lp:zeitgeist

2010-11-09 Thread Markus Korn
Markus Korn has proposed merging lp:~thekorn/zeitgeist/fix-672965-opt_timerange_queries into lp:zeitgeist. Requested reviews: Zeitgeist Framework Team (zeitgeist) Related bugs: #672965 find_event() queries with timerange other than TimeRange.always() are slow

[Zeitgeist] [Bug 626492] Re: Log rar and zip files as archives

2010-11-09 Thread Mikkel Kamstrup Erlandsen
Added zeitgeist as affected since lp:libzeitgeist now pulls the mimetype mappings from there. Archive types we should recognize off the top of my head: tar, zip, and ar. We also have gz, bz2 which are not strictly archives, but just compression types, but I wouldn't object if we log them as

Re: [Zeitgeist] [Merge] lp:~thekorn/zeitgeist/fix-672965-opt_timerange_queries into lp:zeitgeist

2010-11-09 Thread Markus Korn
The question which came in my mind after changing the code was: does the performance of other queries suffer from this change, so I changed the script attached to the bug to test all ResultType Before the change: --- LeastPopularActor: get len(ids)=6 using .find_eventids() in 0.078450s ---

Re: [Zeitgeist] [Merge] lp:~thekorn/zeitgeist/fix-672965-opt_timerange_queries into lp:zeitgeist

2010-11-09 Thread Mikkel Kamstrup Erlandsen
A few comments: * I am not convinced that the perceived improvement is statistically significant. I haven't done the number crunching, but it's a bit fishy... * I'd really like to understand *why* it's bad to use the time index here and why sqlite goes on to use it? Does running ANALYZE

[Zeitgeist] [Bug 672965] Re: find_event() queries with timerange other than TimeRange.always() are slow

2010-11-09 Thread Markus Korn
** Changed in: zeitgeist Status: New = In Progress ** Changed in: zeitgeist Assignee: (unassigned) = Markus Korn (thekorn) ** Changed in: zeitgeist Importance: Undecided = Low ** Changed in: zeitgeist Milestone: None = 0.7.0 -- find_event() queries with timerange other than

[Zeitgeist] [Bug 626492] Re: Log rar and zip files as archives

2010-11-09 Thread Launchpad Bug Tracker
** Branch linked: lp:~kamstrup/zeitgeist/extra-mimes -- Log rar and zip files as archives https://bugs.launchpad.net/bugs/626492 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. Status in Zeitgeist Client

[Zeitgeist] [Bug 602211] Re: Monitoring Create/Move/Copy Files events

2010-11-09 Thread Seif Lotfy
OK I think we can just add 1 column that links to the new uri in the uri table so it becomes id | uri | new_id so i i have a uri xxx 1 | xxx | 1 if its moved or renamed from xxx to yyy we have 1 | xxx | 2 2 | yyy | 2 OR we can do it the other way round by having the new column reference to

[Zeitgeist] [Bug 670355] Re: dynamic loading of extensions

2010-11-09 Thread Seif Lotfy
ok since we already have 3* -1 I am changing the bug to won' fix ** Changed in: zeitgeist Status: New = Won't Fix -- dynamic loading of extensions https://bugs.launchpad.net/bugs/670355 You received this bug notification because you are a member of Zeitgeist Framework Team, which is

[Zeitgeist] [Bug 626492] Re: Log rar and zip files as archives

2010-11-09 Thread Seif Lotfy
** Changed in: zeitgeist Assignee: (unassigned) = Mikkel Kamstrup Erlandsen (kamstrup) ** Changed in: zeitgeist Status: New = In Progress ** Changed in: zeitgeist Milestone: None = 0.7.0 -- Log rar and zip files as archives https://bugs.launchpad.net/bugs/626492 You received

[Zeitgeist] [Merge] lp:~kamstrup/zeitgeist/extra-mimes into lp:zeitgeist

2010-11-09 Thread Mikkel Kamstrup Erlandsen
Mikkel Kamstrup Erlandsen has proposed merging lp:~kamstrup/zeitgeist/extra-mimes into lp:zeitgeist. Requested reviews: Zeitgeist Framework Team (zeitgeist) Related bugs: #626492 Log rar and zip files as archives https://bugs.launchpad.net/bugs/626492 Adds a bunch of extra mimetype

[Zeitgeist] [Bug 673008] [NEW] Reinstall monitors upon startup

2010-11-09 Thread Seif Lotfy
Public bug reported: When for some reason zeitgeist restarts all monitors are then gone Quoting kamstrup: And fwiw - libzeitgeist detects when the daemon comes and goes and reinstates any monitors it has running - so restarting the daemon is not an issue for libzeitgeist customers We should

[Zeitgeist] [Bug 672315] Re: zeitgeist-datasources PPA only for amd64

2010-11-09 Thread Seif Lotfy
** Project changed: zeitgeist = zeitgeist-dataproviders -- zeitgeist-datasources PPA only for amd64 https://bugs.launchpad.net/bugs/672315 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Data-Sources. Status in Zeitgeist

[Zeitgeist] [Bug 670039] Re: missing handle copy/rename/move events

2010-11-09 Thread Seif Lotfy
*** This bug is a duplicate of bug 602211 *** https://bugs.launchpad.net/bugs/602211 ** This bug has been marked a duplicate of bug 602211 Monitoring Create/Move/Copy Files events * You can subscribe to bug 602211 by following this link:

[Zeitgeist] Translation template import - zeitgeist in Zeitgeist Framework 0.1

2010-11-09 Thread rosetta
Hello Zeitgeist Framework Team, On 2010-11-09 13:09z (4 minutes ago), you uploaded a translation template for zeitgeist in Zeitgeist Framework 0.1 in Launchpad. The template has now been imported successfully. Thank you, The Launchpad team ___

Re: [Zeitgeist] [Bug 602211] Re: Monitoring Create/Move/Copy Files events

2010-11-09 Thread Siegfried Gevatter
2010/11/9 Seif Lotfy 602...@bugs.launchpad.net: OK I think we can just add 1 column that links to the new uri in the uri table so it becomes Keep in mind that the same URI can be reused for different things, though. I may rename foo.txt to bar.txt and create a new foo.txt. -- Monitoring

[Zeitgeist] [Bug 672965] Re: find_event() queries with timerange other than TimeRange.always() are slow

2010-11-09 Thread Seif Lotfy
** Also affects: zeitgeist/0.7 Importance: Low Assignee: Markus Korn (thekorn) Status: In Progress -- find_event() queries with timerange other than TimeRange.always() are slow https://bugs.launchpad.net/bugs/672965 You received this bug notification because you are a member of

[Zeitgeist] [Blueprint get-state] Get state of User Activity

2010-11-09 Thread Alex Launi
Blueprint changed by Alex Launi: Whiteboard changed: --- seif 2010-10-27 10:28pm --- Lets discuss this idea. Do we want it as a supported extension or do we want to have in the engine. Or do we want it as a community extension? How relevant is that to our current work? How could it help

[Zeitgeist] [Bug 602211] Re: Monitoring Create/Move/Copy Files events

2010-11-09 Thread Seif Lotfy
** Changed in: zeitgeist Assignee: (unassigned) = Seif Lotfy (seif) ** Changed in: zeitgeist-datahub Status: Incomplete = New -- Monitoring Create/Move/Copy Files events https://bugs.launchpad.net/bugs/602211 You received this bug notification because you are a member of Zeitgeist

[Zeitgeist] [Bug 673008] Re: Reinstall monitors upon startup

2010-11-09 Thread Siegfried Gevatter
** Changed in: zeitgeist Status: New = Confirmed -- Reinstall monitors upon startup https://bugs.launchpad.net/bugs/673008 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. Status in Zeitgeist Framework:

Re: [Zeitgeist] [Bug 602211] Re: Monitoring Create/Move/Copy Files events

2010-11-09 Thread Seif Lotfy
I am aware of that issue and am brainstorming to solve it. for that we will need to have 2 more columns lets try your example: event with foo.txt uri_id | value | new_uri_id | old_uri_id | - 1 | foo.txt | -1 | -1

[Zeitgeist] [Bug 672965] Re: find_event() queries with timerange other than TimeRange.always() are slow

2010-11-09 Thread Launchpad Bug Tracker
** Branch linked: lp:~thekorn/zeitgeist/fix-672965-opt_timerange_queries -- find_event() queries with timerange other than TimeRange.always() are slow https://bugs.launchpad.net/bugs/672965 You received this bug notification because you are a member of Zeitgeist Framework Team, which is

[Zeitgeist] ken-vandine joined zeitgeist-dataproviders

2010-11-09 Thread Zeitgeist Data-Sources Team
Hello Zeitgeist Framework Team, Ken VanDine (ken-vandine) has been added as a member of Zeitgeist Data- Sources Team (zeitgeist-dataproviders) by Seif Lotfy (seif). Follow the link below for more details. https://launchpad.net/~zeitgeist-dataproviders/+member/ken-vandine -- You received

[Gnome-zeitgeist] [Bug 561860] Re: Activity Journal's Right-Click Delete Functionality Broken

2010-11-09 Thread Cando
Recently i noticed that i encounter this problem for example with Bzr events: if i commit 2 times on the same branch, i get only one event in GAJ. That is due to the fact that the two commit-event have the same uri... Imho GAJ should display these 2 events separately for example comparing if the

Re: [Gnome-zeitgeist] [Bug 561860] Re: Activity Journal's Right-Click Delete Functionality Broken

2010-11-09 Thread Siegfried Gevatter
Are you setting the timestamp correctly? -- Activity Journal's Right-Click Delete Functionality Broken https://bugs.launchpad.net/bugs/561860 You received this bug notification because you are a member of GNOME Zeitgeist Team, which is the registrant for GNOME Activity Journal. Status in GNOME

[Zeitgeist] [Bug 602211] Re: Monitoring Create/Move/Copy Files events

2010-11-09 Thread S. Sickert
New db_layout: uri_id (p) | lookup_id (f) | new_uri_id | old_uri_id | - 1 | 1234 | 2 | -1 2 | 1235 | -1 | 1 3 | 1234 | -1 | -1 Lookup Table: id - uri: lookup_id (p) | value --- 1234 | foo.txt 1235 | bar.txt (p) - primary

[Zeitgeist] [Bug 602211] Re: Monitoring Create/Move/Copy Files events

2010-11-09 Thread Seif Lotfy
** Also affects: unity Importance: Undecided Status: New -- Monitoring Create/Move/Copy Files events https://bugs.launchpad.net/bugs/602211 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. Status in

[Zeitgeist] [Bug 602211] Re: Monitoring Create/Move/Copy Files events

2010-11-09 Thread Seif Lotfy
OK what would happen if we use our uri table as our lookup table and add the above table as the uri_tracking_table Another though would be actually to have the normal uri_table and a new update_uri_table where we link and id to its new id so moving foo to bar will give us

[Zeitgeist] [Bug 612344] Re: Blacklist API sucks

2010-11-09 Thread Seif Lotfy
At some point people will need to blacklist over Unity. I think that should be taken in consideration in the new design and development cycle. Example: What if I don't want my .py files to show up in Unity ** Also affects: unity Importance: Undecided Status: New -- Blacklist API