WHOA +1 On Fri, Sep 17, 2010 at 10:40 AM, Siegfried Gevatter <[email protected]>wrote:
> 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 : [email protected] Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp
