Re: [Zeitgeist] [Bug 844877] Re: Query execution slow

2011-09-18 Thread Seif Lotfy
Very interesting. seems to me like the view might be a bit corrupt then... not sure... I think Markus would know more about that On Sun, Sep 18, 2011 at 11:09 PM, Michal Hruby wrote: > And concluding: > > SELECT subj_id, max(timestamp) AS timestamp > FROM event_view >WHERE (((subj_uri = 'a

[Zeitgeist] [Bug 844877] Re: Query execution slow

2011-09-18 Thread Michal Hruby
And concluding: SELECT subj_id, max(timestamp) AS timestamp FROM event_view WHERE (((subj_uri = 'application://gedit.desktop') OR (subj_uri = 'application://devhelp.desktop') OR (subj_uri = 'application://google-chrome.desktop') OR ... GROUP BY subj_id; executes in

[Zeitgeist] [Bug 844877] Re: Query execution slow

2011-09-18 Thread Michal Hruby
And more research: i just tried two queries in `sqlite3` SELECT subj_id FROM event_view WHERE subj_uri IN ('application://gedit.desktop', 'application://firefox.desktop', 'application://devhelp.desktop', 'application://google-chrome.desktop', 'application://dfeet.desktop', 'http://twitter.com

[Zeitgeist] [Bug 844877] Re: Query execution slow

2011-09-18 Thread Michal Hruby
As a note the result is pretty much still the same after seif's fix to get rid of the "AND subj_current_uri = ..." part. -- 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/844877

[Zeitgeist] [Branch ~zeitgeist/zeitgeist/bluebird] Rev 270: remove faulty fixme notice

2011-09-18 Thread noreply
revno: 270 committer: Seif Lotfy branch nick: bluebird timestamp: Sun 2011-09-18 16:13:07 +0200 message: remove faulty fixme notice modified: src/engine.vala -- lp:~zeitgeist/zeitgeist/bluebird https://code.launchpad.net/~zeitgeist

[Zeitgeist] [Branch ~zeitgeist/zeitgeist/bluebird] Rev 269: Handle SIGINT properly.

2011-09-18 Thread noreply
revno: 269 committer: Siegfried-Angel Gevatter Pujals branch nick: bluebird timestamp: Sun 2011-09-18 16:03:46 +0200 message: Handle SIGINT properly. modified: src/zeitgeist-daemon.vala -- lp:~zeitgeist/zeitgeist/bluebird https://c

[Zeitgeist] [Branch ~zeitgeist/zeitgeist/bluebird] Rev 268: added new extensions_conf table for extensions to store their data into

2011-09-18 Thread noreply
revno: 268 committer: Seif Lotfy branch nick: bluebird timestamp: Sun 2011-09-18 15:29:05 +0200 message: added new extensions_conf table for extensions to store their data into modified: src/sql-schema.vala -- lp:~zeitgeist/zeitgei

[Zeitgeist] [Branch ~zeitgeist/zeitgeist/bluebird] Rev 267: exit -> Posix.exit

2011-09-18 Thread noreply
revno: 267 committer: Siegfried-Angel Gevatter Pujals branch nick: bluebird timestamp: Sun 2011-09-18 15:21:31 +0200 message: exit -> Posix.exit modified: src/zeitgeist-daemon.vala -- lp:~zeitgeist/zeitgeist/bluebird https://code.l

[Zeitgeist] [Branch ~zeitgeist/zeitgeist/bluebird] Rev 266: Add FIXME about --replace

2011-09-18 Thread noreply
revno: 266 committer: Siegfried-Angel Gevatter Pujals branch nick: bluebird timestamp: Sun 2011-09-18 15:18:23 +0200 message: Add FIXME about --replace modified: src/zeitgeist-daemon.vala -- lp:~zeitgeist/zeitgeist/bluebird https:/

[Zeitgeist] [Branch ~zeitgeist/zeitgeist/bluebird] Rev 265: Add test cases for events with multiple subjects and FindEvents (re DISTINCT)

2011-09-18 Thread noreply
revno: 265 committer: Siegfried-Angel Gevatter Pujals branch nick: bluebird timestamp: Sun 2011-09-18 14:54:07 +0200 message: Add test cases for events with multiple subjects and FindEvents (re DISTINCT) modified: src/engine.vala t

[Zeitgeist] [Branch ~zeitgeist/zeitgeist/bluebird] Rev 264: engine.vala: add comment about subject templates being AND'ed

2011-09-18 Thread noreply
revno: 264 committer: Siegfried-Angel Gevatter Pujals branch nick: bluebird timestamp: Sun 2011-09-18 14:22:59 +0200 message: engine.vala: add comment about subject templates being AND'ed modified: src/engine.vala -- lp:~zeitgeist/

[Zeitgeist] [Branch ~zeitgeist/zeitgeist/bluebird] Rev 263: testFindTwoOfThreeEvents: move event declarations to a new three_events.js

2011-09-18 Thread noreply
revno: 263 committer: Siegfried-Angel Gevatter Pujals branch nick: bluebird timestamp: Sun 2011-09-18 14:10:22 +0200 message: testFindTwoOfThreeEvents: move event declarations to a new three_events.js added: test/data/three_events.js

[Zeitgeist] [Branch ~zeitgeist/zeitgeist/bluebird] Rev 262: prohibit the datamodel from assiging the current_uri if not set

2011-09-18 Thread noreply
revno: 262 committer: Seif Lotfy branch nick: bluebird timestamp: Sun 2011-09-18 14:07:35 +0200 message: prohibit the datamodel from assiging the current_uri if not set modified: src/datamodel.vala -- lp:~zeitgeist/zeitgeist/bluebi

[Zeitgeist] [Bug 844877] Re: Query execution slow

2011-09-18 Thread Michal Hruby
Ok, I've got another VERY bad one... See attachement ** Attachment added: "query.log" https://bugs.launchpad.net/zeitgeist/+bug/844877/+attachment/2421293/+files/query.log -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitg