On Fri, Aug 19, 2011 at 5:43 PM, Wall-E <[email protected]> wrote: > What I am basically doing in the import is querying the imported DB > and then inserting the result into the application database. I'm not > sure if there is a faster method to do this but if there is any > suggestions is greatly appreciated.
Wrap your work in transactions for large chunks of inserts. By default, each insert is its own transaction and does its own flash writes. Bulk inserts go much faster if you wrap them in your own transactions. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Android Training in Oslo: http://bit.ly/fjBo24 -- 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
