Here is a diff... https://code.edge.launchpad.net/~zeitgeist/zeitgeist/sqlite-insert-improvements/+merge/35701 Here I only set the journal_mode to off since we dont use rollback thus we can not be harmed AFAIK. It improved my average speed to 0.075 seconds which is better.
I also benchmarked the synchronous = OFF for get 0.001 average but a lot of risks come with it. So I did not commit this change. -- Improve insertion times https://bugs.launchpad.net/bugs/639737 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. Status in Zeitgeist Framework: Triaged Bug description: We insert pretty slowly with an average of 0.15 seconds for one event on my core i5 2.5 GHz beast. RainCT had some optimization possibilities: 1) PRAGMA synchronous=OFF 2) PRAGMA journal_mode=OFF The Chat: ------------------------------------------------------------ <kamstrup> I think we are - but I can't recall... in case of failed transactions - but I don't even know if we use transactions these days... <seif> <RainCT> try synchronous=OFF <seif> <RainCT> but it can corrupt your database if your phone dies while ZG is inserting <seif> <RainCT> and journal_mode=MEMORY <seif> <RainCT> or OFF since we don't use rollback anyway <seif> so maybe journal_mode = OFF is a good start? <kamstrup> okay, he's probably right... <kamstrup> 'grep -Ri rollback _zeitgeist/' is your friend :-) <kamstrup> apparently we are not using rollback... More info can be found here: http://www.sqlite.org/pragma.html _______________________________________________ Mailing list: https://launchpad.net/~zeitgeist Post to : [email protected] Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp
