zeitgeist team mailing list archive

[Seif Lotfy <639737@xxxxxxxxxxxxxxxxxx>]

** Summary changed:

- Slow insertion times on maemo
+ Slow insertion times

** Description changed:

- We insert pretty slowly on the maemo
- 0.6 is the average here
- 
- DEBUG:zeitgeist.engine:Inserted 1 events in 0.648254s
+ We insert pretty slowly with an average of 0.15 seconds for one event on
+ my core i5 2.5 GHz beast.

** Summary changed:

- Slow insertion times
+ Improve insertion times

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

-- 
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: New

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