Re: [android-developers] Re: SQLiteDatabase.update() super slow

2010-09-11 Thread Mark Murphy
On Sat, Sep 11, 2010 at 7:17 PM, Sheado wrote: > Thanks guys! You rock! > Transactions did the trick. > > @Mark I'll check out that presentation you mentioned. > > I guess I discounted the flash write as being the bottleneck, because > even at a slow 1.5Mbps write speed I expected better performan

[android-developers] Re: SQLiteDatabase.update() super slow

2010-09-11 Thread Sheado
Thanks guys! You rock! Transactions did the trick. @Mark I'll check out that presentation you mentioned. I guess I discounted the flash write as being the bottleneck, because even at a slow 1.5Mbps write speed I expected better performance (<5-10ms) for writing a few hundred bytes. On Sep 11, 4:

[android-developers] Re: SQLiteDatabase.update() super slow

2010-09-11 Thread Alessandro Pellizzari
On Fri, 10 Sep 2010 19:11:06 -0700, Sheado wrote: > 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

[android-developers] Re: SQLiteDatabase.update() super slow

2010-09-11 Thread Zsolt Vasvari
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 wrote: > Hi All, > > There