I was shocked how slow SQLite works on Android.
For a selection of 374 rows, four columns (two integers and two
strings ~10 chars each), it took about 8 seconds.
Outside android same selection was finished in 63ms.
Of that time about 4 seconds each was taken by
SQLiteStatement.native_1x1_long and
SQLiteStatement.simpleQueryForLong.
Why is it so slow? Is it because of java interface, or sqlite itself
works that slow on Android? Will that be fixed soon?
Code was following
cursor = db.rawQuery("select attr_id, attr_name, attr_value, acc_id
from attributes", null);
while(cursor.next()){
...
}
Db structure can be seen here
http://code.google.com/p/android-tabletop/wiki/DbPresentation
Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
Announcing the new M5 SDK!
http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
