Hi All, There are other posts on this subject, but no real answer anywhere.
The issue: SQLiteDatabase.update(...) takes anywhere from 30ms to 700ms on a simple update (on a Motorola Droid). I'm not sure why there's such a huge range in the timing, but despite that it still means that in the best case updating one column in 30 rows will take at least one second - in the best case! On average updating 30-40 rows is taking me 3-4 seconds - this is crazy slow - like 1985 computer slow! I've tried: * update(...) with ContentValues * update with execSql() * add/removing indices on the columns in question Is there anything else I can try to improve performance? For example, is there any way to update multiple rows with one statement? Any suggestions? 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 android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
