Multi Benchmarking Results - Bad SQLite performance

---

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.

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

Originally Posted by 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.

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

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.

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

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

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

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.

Originally Posted by 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.

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...

Originally Posted by 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.

You might be onto something here.

Sent from my HTC Sensation Z710e using xda premium