[Zeitgeist] [Bug 641100] Re: ZeitgeistEngine.__init__(): statement to get last row id is not using the index
** Changed in: zeitgeist Status: Fix Committed = Fix Released -- ZeitgeistEngine.__init__(): statement to get last row id is not using the index https://bugs.launchpad.net/bugs/641100 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. Status in Zeitgeist Framework: Fix Released Bug description: The attached script is creating a log with ~49k events. In the constructor of ZeitgeistEngine we need to search for the minimum and maximum event id. In the script I'm doing two different ways of getting these values: Our current query: SELECT MIN(id), MAX(id) FROM event - this is not using the event index, and takes about 0.096 secunds for me do the same in two queries: SELECT MIN(id) FROM event+SELECT MAX(id) FROM event - both queries are using the index, and together they take about 0.003 for me I suggest changing the one query into two to get some speedups. ___ Mailing list: https://launchpad.net/~zeitgeist Post to : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp
[Zeitgeist] [Bug 641100] Re: ZeitgeistEngine.__init__(): statement to get last row id is not using the index
** Changed in: zeitgeist Milestone: None = 0.5.2 -- ZeitgeistEngine.__init__(): statement to get last row id is not using the index https://bugs.launchpad.net/bugs/641100 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. Status in Zeitgeist Framework: Fix Committed Bug description: The attached script is creating a log with ~49k events. In the constructor of ZeitgeistEngine we need to search for the minimum and maximum event id. In the script I'm doing two different ways of getting these values: Our current query: SELECT MIN(id), MAX(id) FROM event - this is not using the event index, and takes about 0.096 secunds for me do the same in two queries: SELECT MIN(id) FROM event+SELECT MAX(id) FROM event - both queries are using the index, and together they take about 0.003 for me I suggest changing the one query into two to get some speedups. ___ Mailing list: https://launchpad.net/~zeitgeist Post to : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp
[Zeitgeist] [Bug 641100] Re: ZeitgeistEngine.__init__(): statement to get last row id is not using the index
** Attachment added: min-max-test.py https://bugs.edge.launchpad.net/bugs/641100/+attachment/1597228/+files/min-max-test.py -- ZeitgeistEngine.__init__(): statement to get last row id is not using the index https://bugs.launchpad.net/bugs/641100 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 Bug description: The attached script is creating a log with ~49k events. In the constructor of ZeitgeistEngine we need to search for the minimum and maximum event id. In the script I'm doing two different ways of getting these values: Our current query: SELECT MIN(id), MAX(id) FROM event - this is not using the event index, and takes about 0.096 secunds for me do the same in two queries: SELECT MIN(id) FROM event+SELECT MAX(id) FROM event - both queries are using the index, and together they take about 0.003 for me I suggest changing the one query into two to get some speedups. ___ Mailing list: https://launchpad.net/~zeitgeist Post to : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp
[Zeitgeist] [Bug 641100] Re: ZeitgeistEngine.__init__(): statement to get last row id is not using the index
** Branch linked: lp:~thekorn/zeitgeist/fix-641100-min-max-use-index -- ZeitgeistEngine.__init__(): statement to get last row id is not using the index https://bugs.launchpad.net/bugs/641100 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 Bug description: The attached script is creating a log with ~49k events. In the constructor of ZeitgeistEngine we need to search for the minimum and maximum event id. In the script I'm doing two different ways of getting these values: Our current query: SELECT MIN(id), MAX(id) FROM event - this is not using the event index, and takes about 0.096 secunds for me do the same in two queries: SELECT MIN(id) FROM event+SELECT MAX(id) FROM event - both queries are using the index, and together they take about 0.003 for me I suggest changing the one query into two to get some speedups. ___ Mailing list: https://launchpad.net/~zeitgeist Post to : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp
Re: [Zeitgeist] [Bug 641100] Re: ZeitgeistEngine.__init__(): statement to get last row id is not using the index
WHOA +1 On Fri, Sep 17, 2010 at 10:40 AM, Siegfried Gevatter rai...@ubuntu.comwrote: 1. +1 2. SQLITE sucks. Big time. -- ZeitgeistEngine.__init__(): statement to get last row id is not using the index https://bugs.launchpad.net/bugs/641100 You received this bug notification because you are subscribed to The Zeitgeist Project. Status in Zeitgeist Framework: New Bug description: The attached script is creating a log with ~49k events. In the constructor of ZeitgeistEngine we need to search for the minimum and maximum event id. In the script I'm doing two different ways of getting these values: Our current query: SELECT MIN(id), MAX(id) FROM event - this is not using the event index, and takes about 0.096 secunds for me do the same in two queries: SELECT MIN(id) FROM event+SELECT MAX(id) FROM event - both queries are using the index, and together they take about 0.003 for me I suggest changing the one query into two to get some speedups. -- This is me doing some advertisement for my blog http://seilo.geekyogre.com -- ZeitgeistEngine.__init__(): statement to get last row id is not using the index https://bugs.launchpad.net/bugs/641100 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 Bug description: The attached script is creating a log with ~49k events. In the constructor of ZeitgeistEngine we need to search for the minimum and maximum event id. In the script I'm doing two different ways of getting these values: Our current query: SELECT MIN(id), MAX(id) FROM event - this is not using the event index, and takes about 0.096 secunds for me do the same in two queries: SELECT MIN(id) FROM event+SELECT MAX(id) FROM event - both queries are using the index, and together they take about 0.003 for me I suggest changing the one query into two to get some speedups. ___ Mailing list: https://launchpad.net/~zeitgeist Post to : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp
[Zeitgeist] [Bug 641100] Re: ZeitgeistEngine.__init__(): statement to get last row id is not using the index
** Changed in: zeitgeist Status: In Progress = Fix Committed -- ZeitgeistEngine.__init__(): statement to get last row id is not using the index https://bugs.launchpad.net/bugs/641100 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. Status in Zeitgeist Framework: Fix Committed Bug description: The attached script is creating a log with ~49k events. In the constructor of ZeitgeistEngine we need to search for the minimum and maximum event id. In the script I'm doing two different ways of getting these values: Our current query: SELECT MIN(id), MAX(id) FROM event - this is not using the event index, and takes about 0.096 secunds for me do the same in two queries: SELECT MIN(id) FROM event+SELECT MAX(id) FROM event - both queries are using the index, and together they take about 0.003 for me I suggest changing the one query into two to get some speedups. ___ Mailing list: https://launchpad.net/~zeitgeist Post to : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp
