zeitgeist team mailing list archive

[Seif Lotfy <639737@xxxxxxxxxxxxxxxxxx>]

** 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