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

2011-05-07 Thread Seif Lotfy
** Changed in: zeitgeist Status: Fix Committed = Fix Released -- 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/632363 Title: Slow queries: SQL indexes not used Status

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

2011-04-09 Thread Seif Lotfy
Its more or less 30 times slower now ** Changed in: zeitgeist Importance: Undecided = High -- 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/632363 Title: Slow queries:

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

2011-04-09 Thread Seif Lotfy
I am pretty sure the problem occurred because we added 2 new columns event.origin and event.subj_id_current @thekorn can you look at that if possible -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework.

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

2011-04-09 Thread Seif Lotfy
It also could be related to the new storage columns in the view :) -- 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/632363 Title: Slow queries: SQL indexes not used Status

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

2011-01-19 Thread Seif Lotfy
** Changed in: zeitgeist Milestone: None = 0.8.0 -- 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/632363 Title: Slow queries: SQL indexes not used Status in Zeitgeist

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

2011-01-17 Thread Seif Lotfy
** Changed in: zeitgeist Milestone: 0.7.0 = None -- 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/632363 Title: Slow queries: SQL indexes not used Status in Zeitgeist

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

2010-12-28 Thread Siegfried Gevatter
Is this still a problem or have all instances been fixed by now? -- 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/632363 Title: Slow queries: SQL indexes not used Status in

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

2010-11-10 Thread Markus Korn
Bug 673394 describes anopther 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 Framework:

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

2010-11-10 Thread Markus Korn
Also, bug 673452 -- 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 Framework: Confirmed Bug description: THE

[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 632363] Re: Slow queries: SQL indexes not used

2010-09-13 Thread Seif Lotfy
OK I did some ugly printing to the statements lp:~zeitgeist/+junk/explain-queries just run it and watch the statement and the explanations get printed... http://pastebin.com/FL44gbSY -- Slow queries: SQL indexes not used https://bugs.launchpad.net/bugs/632363 You received this bug

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

2010-09-13 Thread Mikkel Kamstrup Erlandsen
Attached branch lp:~zeitgeist/zeitgeist/explain-logs that implements part 1) of my battle plan above. Based off Seif's work from his previous comment ** Branch linked: lp:~zeitgeist/zeitgeist/explain-logs -- Slow queries: SQL indexes not used https://bugs.launchpad.net/bugs/632363 You received

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

2010-09-07 Thread Markus Korn
just for the record: http://www.sqlite.org/optoverview.html ** Changed in: zeitgeist Milestone: None = 0.6 -- 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

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

2010-09-07 Thread Seif Lotfy
** Changed in: zeitgeist Milestone: 0.6 = 0.7 -- 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 Framework: New

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

2010-09-07 Thread Mikkel Kamstrup Erlandsen
The document Markus points to seems to indicate that my simple OR query above would indeed be optimized to use the index. However I am still pretty convinced that we are not using the indexes in our own queries, given the speeds I see. -- Slow queries: SQL indexes not used