Jump to content


Photo

6 Apr r1: SQLite performance enhancement

* * * * * 1 votes

  • Please log in to reply
27 replies to this topic

#1
PaulOBrien

PaulOBrien

    It's My Party

  • Founder
  • PipPipPipPipPipPip
  • 36,254 posts
  • Gender:Male
  • Location:Norwich, UK
  • Devices:All the Nexus!
  • Twitter:@paulobrien
zerocoolriddler at XDA-developers pointed me in the direction of a SQLite mod that could potentially improve performance on our devices, detailed in this post.

I'm implemented it by recompiling patched source as appropriate and I now consistently hit well over 3,000 on Quadrant. :D

I'll be including the fix in MCR Fr8, but in the meantime, you can apply the update below from recovery to your existing ROM.
  • DOWNLOAD (Mediafire Pro) - MD5: f72abe12ca9fc263eef4078636db842a
Enjoy! B)

P

  • 0

You can follow me on Twitter - http://twitter.com/paulobrien / Follow MoDaCo on Twitter - http://twitter.com/modaco

Want to donate? MoDaCo is raising money for the Multiple Sclerosis society.

Posted Image


#2
PaulOBrien

PaulOBrien

    It's My Party

  • Founder
  • PipPipPipPipPipPip
  • 36,254 posts
  • Gender:Male
  • Location:Norwich, UK
  • Devices:All the Nexus!
  • Twitter:@paulobrien
This is with all my ton of crap installed and running on the device too....!

P

Posted Image

  • 0

You can follow me on Twitter - http://twitter.com/paulobrien / Follow MoDaCo on Twitter - http://twitter.com/modaco

Want to donate? MoDaCo is raising money for the Multiple Sclerosis society.

Posted Image


#3
PaulOBrien

PaulOBrien

    It's My Party

  • Founder
  • PipPipPipPipPipPip
  • 36,254 posts
  • Gender:Male
  • Location:Norwich, UK
  • Devices:All the Nexus!
  • Twitter:@paulobrien
This should work on any ROM btw!

P

  • 0

You can follow me on Twitter - http://twitter.com/paulobrien / Follow MoDaCo on Twitter - http://twitter.com/modaco

Want to donate? MoDaCo is raising money for the Multiple Sclerosis society.

Posted Image


#4
ghale

ghale

    Emperor of the New World

  • Members
  • Pip
  • 43 posts
  • Gender:Male
  • Location:Italy
  • Interests:Cat, books, music, Android
  • Devices:Samsung Galaxy S II
  • Twitter:@ghale76
Just installed!
Thx!

This should work on any ROM btw!

P


  • 0

#5
Mr.HTML

Mr.HTML

    Newbie

  • Members
  • Pip
  • 13 posts
  • Devices:LG Optimus 2X
Just made a clean install of MCK FR7, installed the Overclocking kernal and just about to install this.

Which benchmark app do you use?

  • 0

#6
Sorensiim

Sorensiim

    Grumpy ol' bastard

  • Members
  • PipPip
  • 119 posts
  • Location:The Land of Pork and Taxes
  • Devices:LG2X
  • Twitter:@sorensiim
Imagine if somebody combined this fix with a barebones FR7 mcr bake and the OC kernel from XDA. All known tweaks, running at 1400Mhz could be fun... For benchmarking, and not much else :D

Will be installing this as soon as I'm done copying roughly 5 metric tons of crap to my microsd - All phones should come with USB3 and 160gb of 6 GPBS internal storage, yet maintain their current size and battery life. And have them make coffe too, while you're at it.

Edit: Lol, look at the post above mine. If Quadrant was an olympic disciplin, all Modaco users would be asked to supply urine samples.

Edited by Sorensiim, 06 April 2011 - 10:28 AM.

  • 0
ADHD is an abbreviation of Attention Deficit H... Oooh, shiney!

#7
sibbor

sibbor

    Regular

  • Members
  • PipPip
  • 71 posts
  • Gender:Not Telling
  • Devices:HTC One X, LG Optimus 2x
  • Twitter:@sibbor

This should work on any ROM btw!

P

Going to try it soon. I'm not sure I would have included it in Fr8 though... but perhaps keep it as an external ZIP file we could flash:

"SQLite executes an fsync() system call (or the equivalent) at key points to make certain that critical data has actually been written to the disk drive surface. Synchronization is necessary to guarantee the integrity of the database if the operating system crashes or the computer powers down unexpectedly in the middle of a database update. The second time reported for SQLite is when synchronization is turned off. With synchronization off, SQLite is sometimes much faster, but there is a risk that an operating system crash or an unexpected power failure could damage the database."

- not sure if this is too good on a device where crashes occur and we're running on battery. But, can be a false alert though.

Gonna flash your .9 based kernel before testing this also: r4-mck-ext4-2x-unsigned.zip.
And see if this fixes freezes and crashes, otherwise I'm affraid my device will be eaten up from its inside ;-)

Thanks sharing your great findings, P!

Edited by sibbor, 06 April 2011 - 10:33 AM.

  • 0
HTC One X, LG Optimus 2X

#8
Mr.HTML

Mr.HTML

    Newbie

  • Members
  • Pip
  • 13 posts
  • Devices:LG Optimus 2X
My phone wont boot up anymore after installing this and making a reboot.

On the otherside, it may be the kernel installed?

  • 0

#9
moonie17

moonie17

    Regular

  • MoDaCo Silver
  • PipPip
  • 73 posts
  • Location:Jersey
  • Devices:HTC Hero, LG 2x
Love it! Working like a dream :D got the 1.2 OC kernel....

Attached Files


  • 0

#10
PaulOBrien

PaulOBrien

    It's My Party

  • Founder
  • PipPipPipPipPipPip
  • 36,254 posts
  • Gender:Male
  • Location:Norwich, UK
  • Devices:All the Nexus!
  • Twitter:@paulobrien
Wow, that's nuts!

P

  • 0

You can follow me on Twitter - http://twitter.com/paulobrien / Follow MoDaCo on Twitter - http://twitter.com/modaco

Want to donate? MoDaCo is raising money for the Multiple Sclerosis society.

Posted Image


#11
ghale

ghale

    Emperor of the New World

  • Members
  • Pip
  • 43 posts
  • Gender:Male
  • Location:Italy
  • Interests:Cat, books, music, Android
  • Devices:Samsung Galaxy S II
  • Twitter:@ghale76

Love it! Working like a dream :D got the 1.2 OC kernel....


Argh! 3734!!!
I have 3089!

  • 0

#12
moonie17

moonie17

    Regular

  • MoDaCo Silver
  • PipPip
  • 73 posts
  • Location:Jersey
  • Devices:HTC Hero, LG 2x
I know eh! might install the 1.4 just for the crack to see if i can break the 4K mark :D

  • 0

#13
utp

utp

    Newbie

  • Members
  • Pip
  • 3 posts
  • Devices:586w
Arm....I am on stock 10A, build date ro.build.date.utc=1299570033

After I install SQLite the mark dropped from 2541 to 2513....strange....

Am I missing anything?

Thanks!!!!!!!

  • 0

#14
Mr.HTML

Mr.HTML

    Newbie

  • Members
  • Pip
  • 13 posts
  • Devices:LG Optimus 2X

I know eh! might install the 1.4 just for the crack to see if i can break the 4K mark :D


Just installed the 1.4 OC.

And gues what B)

The 4K mark is broken ;)

EDIT:
Made another benchmark, got better :D

Attached Files


Edited by Mr.HTML, 06 April 2011 - 11:01 AM.

  • 0

#15
poi2005

poi2005

    Regular

  • Members
  • PipPip
  • 52 posts
  • Gender:Male
  • Devices:Samsung Galaxy Nexus, SGS3

Just installed the 1.4 OC.

And gues what :D

The 4K mark is broken B)

EDIT:
Made another benchmark, got better ;)


This is crazy. Does OC consume more battery life?

  • 0

#16
yoel740

yoel740

    Newbie

  • Members
  • Pip
  • 9 posts
Installed
I got 3078 :D

  • 0

#17
Mr.HTML

Mr.HTML

    Newbie

  • Members
  • Pip
  • 13 posts
  • Devices:LG Optimus 2X

This is crazy. Does OC consume more battery life?


Ofc it will , how much, i dont know :D

  • 0

#18
gensplejs

gensplejs

    Regular

  • MoDaCo Silver
  • PipPip
  • 103 posts

Installed
I got 3078 :D

You need to install overclocked kernel from XDA to get the higher numbers poster...
1.2ghz or 1.4 ghz kernel...should give a lot more than 3000k


with the default fr7 kernel and sql fix i get between 2900 and 3080

  • 0

#19
moonie17

moonie17

    Regular

  • MoDaCo Silver
  • PipPip
  • 73 posts
  • Location:Jersey
  • Devices:HTC Hero, LG 2x
no way!! that is unreal....

  • 0

#20
Schmew

Schmew

    Newbie

  • Members
  • Pip
  • 16 posts
  • Devices:Adam Pixel Qi, LG P990
What the hell i just woke up and found this thread, am i still dreaming ? 4.2k ?! I want :D

  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users