• Announcements

    • 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 softwareNintendo 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 authorISSUES If you have any issues with this policy, please contact PaulOBrien directly via PM.
    • 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.
Sign in to follow this  
Followers 0

6 Apr r1: SQLite performance enhancement

28 posts in this topic

Posted · Report post

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

Share this post


Link to post
Share on other sites

Posted · Report post

This is with all my ton of crap installed and running on the device too....!

P

newquadrant.png

0

Share this post


Link to post
Share on other sites

Posted · Report post

This should work on any ROM btw!

P

0

Share this post


Link to post
Share on other sites

Posted · Report post

Just installed!

Thx!

This should work on any ROM btw!

P

0

Share this post


Link to post
Share on other sites

Posted · Report post

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

Share this post


Link to post
Share on other sites

Posted (edited) · Report post

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
0

Share this post


Link to post
Share on other sites

Posted (edited) · Report post

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
0

Share this post


Link to post
Share on other sites

Posted · Report post

My phone wont boot up anymore after installing this and making a reboot.

On the otherside, it may be the kernel installed?

0

Share this post


Link to post
Share on other sites

Posted · Report post

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

post-685169-1302086855_thumb.png

0

Share this post


Link to post
Share on other sites

Posted · Report post

Wow, that's nuts!

P

0

Share this post


Link to post
Share on other sites

Posted · Report post

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

Argh! 3734!!!

I have 3089!

0

Share this post


Link to post
Share on other sites

Posted · Report post

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

0

Share this post


Link to post
Share on other sites

Posted · Report post

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

Share this post


Link to post
Share on other sites

Posted (edited) · Report post

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

post-866472-1302087569_thumb.png

post-866472-1302087700_thumb.png

Edited by Mr.HTML
0

Share this post


Link to post
Share on other sites

Posted · Report post

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

Share this post


Link to post
Share on other sites

Posted · Report post

Installed

I got 3078 :D

0

Share this post


Link to post
Share on other sites

Posted · Report post

This is crazy. Does OC consume more battery life?

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

0

Share this post


Link to post
Share on other sites

Posted · Report post

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

Share this post


Link to post
Share on other sites

Posted · Report post

no way!! that is unreal....

0

Share this post


Link to post
Share on other sites

Posted · Report post

What the hell i just woke up and found this thread, am i still dreaming ? 4.2k ?! I want :D

0

Share this post


Link to post
Share on other sites

Posted · Report post

why recently i cannot using Dolphin to download file form Paul loadbalancing server ???

Working for me.

0

Share this post


Link to post
Share on other sites

Posted · Report post

I installed this and i'm hitting 3162 (with no overclocking) sweet!!

0

Share this post


Link to post
Share on other sites

Posted · Report post

Can you guys help me out, i dont have any experience at all with this and i want to try the 1.2 Kernel, the thread @ xda doesnt seem to explain properly how to do it.

0

Share this post


Link to post
Share on other sites

Posted · Report post

I installed this and i'm hitting 3162 (with no overclocking) sweet!!

Even at 816 mhz with SetCPU and some apps running i get still 2600 (Rollback Kernel installed)

Nice work Pau very Nice!

No more Browser Hickups on Wifi i love it!

0

Share this post


Link to post
Share on other sites

Posted · Report post

This isn't the 1.2 kernel thread.

P

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
Sign in to follow this  
Followers 0

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