Are you using bulkInsert?
On Wed, Sep 2, 2009 at 8:47 AM, mjc147<[email protected]> wrote: > > I need to insert approximately one million rows of data (spread over 4 > tables) - each row has one or two numeric fields, and two or three > text fields (normally quite short). Single-column indexes on all the > fields. > > After doing some tests on the emulator with a small test set, I > extrapolated (assuming the last row will be inserted with a similar > speed to the first row) my results to figure out that this would take > about 15 hours (I have a Core 2 Duo running Vista). > > However, then I tried running the small test set on my Hero and I was > surprised to see it run more than four times faster. I would guess it > would take about 3 hours on the Hero. > > Alternatively, I could make the pre-populated database available as a > download on the first run but this is likely to be a 120MB download. > > I have a few questions I'm hoping someone can help me with: > > 1. SQLite performance on the actual device being 4-5 times faster > compared to the emulator - is this normal/expected? > 2. Do the figures above generally sound fast/slow/normal (sorry this > is so vague)? > 3. From a user perspective - would it be best to provide a 120MB > download or a 3 hour "first-time initialisation" step (plus 6MB > download)? > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
