i'm glad , because you put the ,, patched libsqlite ,, in your update (1.7) ...
its a great work from ,, mik_os ( a great developer )
i think that this version , gonna make even happier the users of your rom...
i'm a fan of your work , even if i'm steel riding my horse ...
congratsulations again ..
for those who still wondering what it does
read this and i hope you'll understand.......
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.
After modified, the time of insert 2000 records to sqlite3 db, from 1m11s reduce to 2s.
With Android applications, the database operation is non-persistent, normal step in app is:
with step3, the data in cache will be flush to disk. so user will not notice any sudden lag, always smooth.
With SYNC-ON, the db operation like this:
2.1. write a record/do a transcation
2.3. write a record/do a transcation
with SYNC-OFF, operation like this:
2.1 write a record/do a transcation
2.2 write a record/do a transcation
3. close db/fsync()
So, no-sync can significantly save IO time.