Patched SQLITE3(libsqlite.so) for 2.2 and 2.3 - Optimus One, P500, V General

IMPROVE YOUR I/O SCORE BY PATCHING YOUR SQLITE3(LIBSQLITE.SO)
More info on how to disable sync in sqlite3 without pragma here
DISCLAMER: Do not try this if you do not understand what it does to your phone. I am not responsible for anything bad happening to your phone!!!!!
ALWAYS PERFORM A BACKUP BEFORE USING MODS LIKE THIS
Download your specific libsqlite.so copy it to /system/lib with any method you prefer(root explorer suggestd) thus overwriting the existing libsqlite.so(you did make a backup right?). Set permission to "rw-r--r--"
Using "RL SQL benchmarking tool"(stock 600mhz clock speed, with ungaze data2sd and dalvik-cache to ram:
BEFORE:
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
AFTER:
LOWER IS BETTER!!!!! (I can get higher scores but this is just to show you the benefits of the patch)
Patched libsqlite.so for 2.2(thanks to mmarz for the link)(someone please confirm if it also works for 2.2.1/2.2.2)
Patched libsqlite.so for 2.3 by:mik_os
Flashable zips (extract the package first then choose the desired zip to apply) contains original & patched libsqlite for froyo and CM7
Words from author:
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:
1.open db
2.do read/write
3.close db
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:
1.open db
2.1. write a record/do a transcation
2.2. fsync()
2.3. write a record/do a transcation
2.4. fsync()
.....
3.close db/fsync()
with SYNC-OFF, operation like this:
1.open db
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.
Click to expand...
Click to collapse
Here's additional info from patched 2.3 libsqlite.so:
http://forum.xda-developers.com/showpost.php?p=12695464&postcount=1966
-----OBSOLETE-----
So theoretically, this can help improve our phones. Unfortunately, our libsqlite.so is not compatible with the hex values provided. Another way is to compile libsqlite from source which I have no knowledge of. So if anyone can help, I think the whole O1 community would be very grateful.
Need help for a patched 2.2 libsqlite.so

---

without sync to file(-system) you possibly can loose data.
SQLite3 is a flat file DB which underlaying system is XML - each insertion is writing directly to a file, and this must be in synch
with filesystem because of file mistakes/corruption i think. if you use a network connection like mysql this is other, than the remote system is synching.

---

I would be so grateful if any of the devs taught us how to change this, or even post a flashable zip since, in theory, increases performance.

---

from author:
You may still loose data on a powerloss because it is not yet synced but you wont have corrupted data because half written data will be fixed on a ordered journal.
Click to expand...
Click to collapse
and yaffs2 and ext4 are journaled filesystems right? that's what we use.

---

ungaze said:
from author:
and yaffs2 and ext4 are journaled filesystems right? that's what we use.
Click to expand...
Click to collapse
i think a journaling filesystem is useless if you loose data within writing to a file.
BTW: yaffs2 is not journaling and many users doesnt have ext4 as system partition but only as data partition on sdhc

---

Up, since we already have patched libsqlite.so for 2.3 http://forum.xda-developers.com/showpost.php?p=12695464&postcount=1966, maybe someone can patch the one for 2.2?
@dookmatt
Still looking for the stuff you need

---

boss question , this trick initially came from samdroid right?
so we can just copy paste the .so file?

---

Is this what you're looking for? http://forum.xda-developers.com/showthread.php?t=947975

---

cmangalos said:
boss question , this trick initially came from samdroid right?
so we can just copy paste the .so file?
Click to expand...
Click to collapse
Actually came from XDA-HTC desire thread then ported to spica in samdroid. And that's where I got the idea and was hoping we could use it here.
Copy and paste + set right permissions. Remember, patch libsqlite.so for 2.3 is for 2.3 only. Make sure you know what you're doing and always make a backup when trying out stuff like these.
@mmarz
Yes basically that's the same as what we(I) need, only we need something specifically for optimus 2.2 source. I really don't understand making stuff from source but I'll still give your link a try.
@dookmatt
theres some discussion going on on how to do this from sources in the last pages of this thread: http://forum.xda-developers.com/showthread.php?t=903507&page=9

---

Yup im already through doing it, since i really saw the significance of this file on spica, it really boost up the i/o which is commonly the downside of o1

---

See if this works. I can boot up using it, but I'm not sure how to test if it worked.

---

Thanks a ton mmarz. It worked. With data2sd(check my sig), before I had 2k - 2.4k I/O score with quadrant. Now I have 3k++ thanks to this patched libsqlite.so. Will add it to first post.(I think this should be moved to dev section now that it's properly addressed to)

---

ungaze, any idea what version of patch is included in franciscofranco tweeks package?
I'm using that patch on 2.3.3

---

Tested on 2.2.2 and it's working.... but not so great improve noted.

---

Yeah i confirm patched froyo libsqlite works on froyo 2.2.2 even. openOptimus' last build has this patch

---

Samhain77 said:
Tested on 2.2.2 and it's working.... but not so great improve noted.
Click to expand...
Click to collapse
I also don't get much of an improvement in quadrant. I'm not sure why.

---

nice app, i like it... thanks to sharing

---

I get + 1k on I/O score.
Anyways, I'll post another benchmarking tool that clearly shows improvement once I get back to PC.

---

Did you get on a PC?

---

Magnumutz said:
Did you get on a PC?
Click to expand...
Click to collapse
lololol very funny. Wise guy
well, with recent events regarding my data2sd, I can't find time to post results yet(or even find the benchmarking app). Hopefully next build will be stable and I WILL post the said benchmarking results.
It's true LOL!