Multi Benchmarking Results - Bad SQLite performance

[dagrim1]

Being quite happy overall with the prime I couldn't help feeling certain things are very slow, mainly IO actions. Restoring titanium backups takes ages for example.

So I decided to do some extensive benchmarking using the i9100 and TF201 (for now, will add the TF101 later as well) to see how exactly the prime performs. I used the following benchmarks and ran them 3 times each (TF201 in performance mode, CFQ scheduler):

RL Benchmark - SQLite performnace
Androbench
CF-Bench v1.1
Antutu Benchmark
Benchmark (from softweg)

And I'm mostly blown away by the pathetic sqlite performance (and related, the disk performance). See screenshot for a summary (the .xls contains all the results).

1000 inserts taking 68 secs on the tf201 vs 0.6 secs on the i9100!!!
drop table taking 2+ secs on the tf201 vs 0.1 on the i9100

seq. read: ~20mb/s on the TF201 vs 52+ on the i9100
sqlite (updates and deletes): 18-ish secs on the TF201 vs 6 ish on the i9100.

Is the disk of the TF201 such utter crap? Seems to be... Or are there other ways of improving this. Any other results confirming this?

Looking into possibilities of disabling fsync() btw (http://forum.xda-developers.com/showthread.php?t=903507) but nothing really yet.

 

[roccodaone]

I think it's a well established fact that Primes have a poor disk performance. Is there a solution, though? I don't know.

 

[benefit14snake]

I think it's a well established fact that Primes have a poor disk performance. Is there a solution, though? I don't know.

I firmly firmly believe it is software related. Even if Asus put in the worst flash possible it would not perform but maybe 1/2 to 1/5 as fast. Only time will tell, once Asus/Nvidia has time to focus on things other than critical issues (sleep of death, gps, ect ect ect) maybe disk performance can get hashed out. I think even if Asus did put crappy flash memory in there, they would be smart enough to only go so bad to where it at least contended with some of the competitors. They have been catering to the enthusiast crowd for quite some time and should understand by now that EVERY thing will be benched by its buyers LOL. Sometimes I feel like the EEEpad line is a completely different company than Asus its self though.


Odd thing is my droid razr maxx SMOKES my prime in androbench but does about 10% worse on antutu.


Sent from my EEEPAD using Tapatalk 2

 

[roccodaone]

I certainly hope it's software related. But what makes me skeptical about this is, how come it hasn't been resolved by Asus yet.

 

[yumms]

Disk performance doesn't change in CM9 or AOKP roms, so I don't think it's software related.

 

[undercover]

If it is not hardware it will most likely be to do with firmware/drivers.

 

[benefit14snake]

Im sorry guys. I didnt mean software rom wise i mean firmware for the controller. What i find to be odd is my prime wipes and flashes waaay quicker than my razr maxx.
Also like i said in antutu i score higher which is odd.....

We will see though just seems off for some reeeason.
Sent from my DROID RAZR using Tapatalk 2

 

[peterk-1]

Is sqlite installed ? I can't find it in documented Android locations and sqlite3 entered as a terminal command has no effect. If it isn't installed then Java "sql" must be being used and it has significantly worse performance.

 

[dagrim1]

Is sqlite installed ? I can't find it in documented Android locations and sqlite3 entered as a terminal command has no effect. If it isn't installed then Java "sql" must be being used and it has significantly worse performance.

Hmmm, good one... didn't see it in the usual place. There are some libsqlite.so files and stuff but not the sqlite3 in the xbin folder like there is on the i9100 for example.

Might just try and see what happens if I copy it from the i9100 heh. Tried copying the libsqlite.so and libsqlite_jni.so files from the i9100 to the TF201 but didn't improve anything (was actually surprised I didn;t get errors everywhere, but ok).

Will check it out some more later...

 

[undercover]

Is sqlite installed ? I can't find it in documented Android locations and sqlite3 entered as a terminal command has no effect. If it isn't installed then Java "sql" must be being used and it has significantly worse performance.

You might be onto something here.

Sent from my HTC Sensation Z710e using xda premium

 

[peterk-1]

Here is a thread that that could be properly used for the I/O discussion clogging up the "so what about the upgrade"

 

[leppie]

This tablet is a joke...

RL Benchmark SQLLite:

1.0GHz (Bal) TFP - 124.9 seconds
1.0GHz (Perf) TFP - 120.9 seconds
1.2GHz (Bal) TFP - 112.8 seconds
1.3GHz (Perf) TFP - 116.2 seconds (slower???)
1.6GHz (Perf) TFP - 117.4 seconds (slower again???)

1.0GHz Desire HD - 93.4 seconds
1.5GHz Desire HD - 82.8 seconds

 

[clenz]

Can someone explain why SQLite is so important to my everyday use of the Prime? How will these poor benchmark results manifest in how we use the tablet?

 

[dagrim1]

Can someone explain why SQLite is so important to my everyday use of the Prime? How will these poor benchmark results manifest in how we use the tablet?

SQLite is the way apps store data and retrieve it in android, it's a database system/layer and used just about all the time. So if this is messed, you'll notice.

 

[SteveG12543]

Here are my results on RL Benchmark. (On .28, performance mode)

EDIT: Sorry for the low res pics, here are better ones.

Sent from my Transformer Prime TF201 using XDA Premium HD app.

 

[htcplussony]

Is it me or is the .28 firmware getting even worst results than before.

Does any have the same graph .21 or S2 or S3 or better yet a One X?

EDIT I see yumms posted a graph for his Prime.

 

[leppie]

Here are my results on RL Benchmark. (On .28, performance mode)
Sent from my Transformer Prime TF201 using XDA Premium HD app.

Now I have lost all hope!

I am sure a HTC ChaCha is faster than that.

 

[Rytkonen]

SGS3 first try overall 20.762. There seems to be some serious IO bug.

http://db.tt/TFYUAdjk

 

[SteveG12543]

Now I have lost all hope!

I am sure a HTC ChaCha is faster than that.

As Demandarin said,

Remember this also. As far as I know, asus/nvidia never really got to address i/o issues yet. wasn't at top of list of things to take care of. most complaints publicly came from gps n wifi. then sod, reboots, lockups, etc.. They've been busy addressing other issues first. they will address i/o soon.

Hopefully he's right and they can fix it!

Sent from my ADR6425LVW using XDA Premium.

 

[ex1991eric]

odd... i am getting way way better sqlite performance than any I have seen recently; on locked TFP .21; fresh from factory wipe. On balanced power.