6 Apr r1: SQLite performance enhancement

[Guest Rhysd2]

Paul the kitchen has the ability to disable this in fr8. Why would you want to disable it? pardon the stupid question just wasnt sure and wanted to be sure before baking a rom.

[Guest Paul]

Android phones as the underlying database using sqlite3. sqlite3 writes efficiency is very low, because the sync feature turned on by default, and fsync() must be performed after each insertion, the resulting system efficiency is low, and the disk life is reduced.

I try to disable sync feature by default in exchange for greater IO performance and reduce disk consumption. While doing so may result in data integrity problems, but I still like to use it because most of the sqlite insert action can be completed within a few seconds, not too much to consider issues such as sudden power-down.

See above, I don't see any reports of issues tho...

P

[Guest djmcnz]

I'm starting to get lots of these... I can't open Exchange or Calendar apps (well they open and immediately close)...

Any insight?

I/DEBUG   ( 7479): Build fingerprint: 'google/passion/passion/mahimahi:2.2.2/FRG83G/91102:user/release-keys'


I/DEBUG   ( 7479): pid: 7729, tid: 7734  >>> com.android.providers.calendar <<<


I/DEBUG   ( 7479): signal 11 (SIGSEGV), fault addr 00000000


I/DEBUG   ( 7479):  r0 00000000  r1 00000000  r2 00000000  r3 00000000


I/DEBUG   ( 7479):  r4 00268968  r5 0026a468  r6 0026a260  r7 00241470


I/DEBUG   ( 7479):  r8 4bd5e9c4  r9 430bae18  10 430bae00  fp 0012de20


I/DEBUG   ( 7479):  ip 002688f0  sp 4bd5e7c0  lr 00000000  pc a8b416d4  cpsr 20000030


I/DEBUG   ( 7479):  d0  4000000000000064  d1  3ff0000041f00000


I/DEBUG   ( 7479):  d2  0000000050baf6de  d3  4059000000000000


I/DEBUG   ( 7479):  d4  412e848000000000  d5  412e848c00000000


I/DEBUG   ( 7479):  d6  3ff0000000000000  d7  3ff0000000000000


I/DEBUG   ( 7479):  d8  0000000000000000  d9  c3e0000000000000


I/DEBUG   ( 7479):  d10 0000000000000000  d11 0000000000000000


I/DEBUG   ( 7479):  d12 0000000000000000  d13 0000000000000000


I/DEBUG   ( 7479):  d14 0000000000000000  d15 0000000000000000


I/DEBUG   ( 7479):  scr 80000012


I/DEBUG   ( 7479): 


I/DEBUG   ( 7479):		  #00  pc 000416d4  /system/lib/libsqlite.so


I/DEBUG   ( 7479):		  #01  lr 00000000  <unknown>


I/DEBUG   ( 7479): 


I/DEBUG   ( 7479): code around pc:


I/DEBUG   ( 7479): a8b416b4 94411a5c 9a229230 e104f8dd c0a0f8dd 


I/DEBUG   ( 7479): a8b416c4 bf9a4572 92299a30 f8cc2200 98302054 


I/DEBUG   ( 7479): a8b416d4 f0137803 d1020f80 2001933e a93ee002 


I/DEBUG   ( 7479): a8b416e4 fc10f7c3 9b3e9040 0718f8df d9064283 


I/DEBUG   ( 7479): a8b416f4 506cf24d f8f0f7cd f0029008 2105bd0f 


I/DEBUG   ( 7479): 


I/DEBUG   ( 7479): code around lr:


I/DEBUG   ( 7479): 


I/DEBUG   ( 7479): stack:


I/DEBUG   ( 7479):	 4bd5e780  0025edbc  [heap]


I/DEBUG   ( 7479):	 4bd5e784  0025ee0c  [heap]


I/DEBUG   ( 7479):	 4bd5e788  00268988  [heap]


I/DEBUG   ( 7479):	 4bd5e78c  a8b063cb  /system/lib/libsqlite.so


I/DEBUG   ( 7479):	 4bd5e790  00000000  


I/DEBUG   ( 7479):	 4bd5e794  00241470  [heap]


I/DEBUG   ( 7479):	 4bd5e798  4bd5e9c4  


I/DEBUG   ( 7479):	 4bd5e79c  0000000d  


I/DEBUG   ( 7479):	 4bd5e7a0  00000000  


I/DEBUG   ( 7479):	 4bd5e7a4  00000058  


I/DEBUG   ( 7479):	 4bd5e7a8  0026a468  [heap]


I/DEBUG   ( 7479):	 4bd5e7ac  0026a260  [heap]


I/DEBUG   ( 7479):	 4bd5e7b0  00241470  [heap]


I/DEBUG   ( 7479):	 4bd5e7b4  a8b06477  /system/lib/libsqlite.so


I/DEBUG   ( 7479):	 4bd5e7b8  df002777  


I/DEBUG   ( 7479):	 4bd5e7bc  e3a070ad  


I/DEBUG   ( 7479): #00 4bd5e7c0  00000000  


I/DEBUG   ( 7479):	 4bd5e7c4  4bd5e848  


I/DEBUG   ( 7479):	 4bd5e7c8  00000000  


I/DEBUG   ( 7479):	 4bd5e7cc  00000000  


I/DEBUG   ( 7479):	 4bd5e7d0  00000000  


I/DEBUG   ( 7479):	 4bd5e7d4  00000000  


I/DEBUG   ( 7479):	 4bd5e7d8  00000000  


I/DEBUG   ( 7479):	 4bd5e7dc  00000000  


I/DEBUG   ( 7479):	 4bd5e7e0  00000000  


I/DEBUG   ( 7479):	 4bd5e7e4  a8b50ab4  /system/lib/libsqlite.so


I/DEBUG   ( 7479):	 4bd5e7e8  a8b50948  /system/lib/libsqlite.so


I/DEBUG   ( 7479):	 4bd5e7ec  00268968  [heap]


I/DEBUG   ( 7479):	 4bd5e7f0  430bab6c  


I/DEBUG   ( 7479):	 4bd5e7f4  00000000  


I/DEBUG   ( 7479):	 4bd5e7f8  0026a5e8  [heap]


I/DEBUG   ( 7479):	 4bd5e7fc  0026a520  [heap]


I/DEBUG   ( 7479):	 4bd5e800  0000000e  


I/DEBUG   ( 7479):	 4bd5e804  a8b50948  /system/lib/libsqlite.so