populate SQL Lite with Huge data

Question

Hi

I need to insert thousands of records into Android - SQL LITE database, on first time of app installation. what is the optimize way to handle this situation. should i Hard code those records in LIST (code) or fetch from File System i.e, CSV or txt or its any other way?

http://stackoverflow.com/a/9109728/265167 – Yaqub Ahmad Mar 06 '12 at 08:20 — Yaqub Ahmad, Mar 06 '12 at 08:20

score 1 · Answer 1 · answered Mar 06 '12 at 05:21

1

I would suggest you to keep your database file in the assets folder and the copy it into databases folder for the first time your application starts. Inserting thousands of record won't be a good idea if you are having static data in your tables.

answered Mar 06 '12 at 05:21

Lalit Poptani

67,150
23
161
242

THanks, i found this URL, http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/ – nalaiqChughtai Mar 06 '12 at 05:45

populate SQL Lite with Huge data

1 Answers1