Can you store the db in res/raw folder, then copy them to the /data folder?
AL wrote: > 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...? >>> > > > -- Thanks. Muthu Ramadoss http://mobeegal.in http://androidrocks.in http://intellibitz.com http://twitter.com/intellibitz http://linkedin.com/in/tellibitz http://slideshare.net/intellibitz http://groups.google.com/group/android-chennai +91 44 22476750 We develop innovative search solutions using LBS for Android. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
