** Changed in: zeitgeist
Assignee: (unassigned) => Seif Lotfy (seif)
** Changed in: zeitgeist
Status: New => Triaged
** Changed in: zeitgeist
Importance: Undecided => Wishlist
** Description changed:
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
--
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
