On Wed, Sep 2, 2009 at 10:18 AM, mjc147<westmead...@yahoo.co.uk> wrote:
>
> On Sep 3, 12:43 am, Marco Nelissen <marc...@android.com> wrote:
>> Are you using bulkInsert?
>
> Actually, I don't. I looked at it but it seemed to be related to
> ContentProvider and ContentResolver neither of which I'm using. Am I
> missing something here?
>
> I use execSQL("INSERT INTO my_table VALUES(?,?,?)", new Object[]
> {1,2,3}) and perform on average 10 calls per transaction.BulkInsert is the provider's way of inserting data in bulk, usually done by using a transaction. Since you're already using a transaction, you should be OK, though you could try increasing the number of inserts per transaction. You might also want to reconsider doing that "new Object" every time. Reusing existing objects would be gentler on the garbage collector. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
