• Announcements

    • PaulOBrien

      Reminder - MoDaCo position on illegal content   07/30/15

      ILLEGAL CONTENT I'd like to just reaffirm MoDaCo's position regarding piracy and illegal content in the light of some recent questions / postings. Posts will be censored by myself or my moderation team if the contain or link to: Illegal / pirated / cracked software or sites that host such software Nintendo emulators / ROMs or sites hosting them (in light of Nintendo's legal stance) CUSTOM ROMS You may discuss and post links to custom device ROMs on MoDaCo, provided the following rules are adhered to: ROMs must not contain any illegal 3rd party software (this includes trial versions included without permission) ROMs must give full credit to the original author ISSUES If you have any issues with this policy, please contact PaulOBrien directly via PM.
    • PaulOBrien

      Reminder: Selling items on the forum directly is not allowed   07/30/15

      Please note that selling items on the forum directly is not allowed by the forum rules. There is a forum for eBay auctions whereby you can list the items on eBay and link to them there. This is the ONLY forum for this type of activity. You may also advertise links to the eBay forum in your signature. Please note that selling directly in contravention of these rules will result in a warning / suspension / ban.
PaulOBrien

6 Apr r1: SQLite performance enhancement

28 posts in this topic

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.

0

Share this post


Link to post
Share on other sites
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

0

Share this post


Link to post
Share on other sites

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

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

MoDaCo is part of the MoDaCo.network, © Paul O'Brien 2002-2016. MoDaCo uses IntelliTxt technology.