OK i was looking at the wrong file. my database is 100kb and the SQL dump is 600kb...
so executing 6500 sql statements takes a while. also there's no function to execute them as a script either so one line per function call doesn't help On Apr 9, 9:02 pm, "Ahti Kitsik" <[EMAIL PROTECTED]> wrote: > AL, > > how can a 11kb-database take 15 minutes to initialize? > You can get the full database dump using from sqlite shell and then play it > back at android startup. > You have to make the "playback" only when the database does not yet exist. > > regs, > Ahti > > On Wed, Apr 9, 2008 at 1:45 PM, AL <[EMAIL PROTECTED]> wrote: > > > I've spent at least 50 hours developing my entry for the android dev > > challenge but now I cant submit it because i need test data in my > > SQLite database or the app is an empty shell. The only way i can > > populate my database is to run execSQL(); one insert statement at a > > time, which takes about 15 minutes during startup, and i dont expect > > anyone to wait more than a few seconds.. And my database size is only > > 11 kilobytes on disk ... the apk file lets you include xml, drawables, > > and raw data but no sql databases, why? > > > have i missed something here or is my entry dead in the water...? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Challenge" 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-challenge?hl=en -~----------~----~----~----~------~----~------~--~---
