** 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
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:
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.
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
** 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
** 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
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
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:
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
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
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
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
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
** 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
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
15 matches
Mail list logo