In addition to the other tips, do the work in the background (e.g., AsyncTask), and 800ms may not be much of an issue.
Bear in mind that you will never be able to completely rid yourself of occasional long delays with flash writes, as that is the nature of the beast. See Brad Fitzpatrick's "Writing Zippy Android Apps" presentation from Google I|O, where he pointed out that, on occasion, writing a *single byte* to flash takes 200ms. On Mon, Nov 1, 2010 at 10:50 PM, Mark Carter <[email protected]> wrote: > I have a database (stored on a Class 6 SD card) with a single empty > table (5 columns). There is an index on each column. > > Performing a single INSERT statement (whether using an SQLiteStatement > or calling SQLiteDatabase.insert()) takes about 800ms on my N1 > (2.2.1). The INSERT statement does NOT do anything fancy (like > subselects). > > Is there any way to speed this up? > > -- > 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 > -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Android 2.2 Programming Books: http://commonsware.com/books -- 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
