Yes, use transaction bracketing for batch updating it makes a HUGE difference.
Invididual updates are very slow, but that's what they, just individual updates. If you do more than 2 updates, using transaction bracketing will help immensily. On Sep 10, 10:11 pm, Sheado <[email protected]> wrote: > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
