Create Sqlite database with 8000 records

Question

I'am developing an application which uses sqlite for autocomplete textview. The database has more than 8000 records. Creating a database can be done with a query in onCreate(). But how do i create a database with 8000+ records in it. writing insert query for 8000 records sounds worst to me.

What's the best way to create a database with 8000+ records in it. Is there any way like dumping sql file like how we do in mysql.

Have you tried the naive solution to just do the INSERT queries (in one single transaction, of course)? What was the result? — Emil Vikström, Apr 23 '12 at 07:23
@EmilVikström No i didn't try that. I thought its a bad idea to do. — Jeyanth Kumar, Apr 23 '12 at 07:42
Why is it a bad idea? For performance reasons or otherwise? If it's for performance reasons, how can you make such a claim without even trying? — Emil Vikström, Apr 23 '12 at 07:47
@EmilVikström its only possible for Sqlite version 3.7.11 and above — Jeyanth Kumar, Apr 23 '12 at 08:46
http://stackoverflow.com/questions/9109438/using-already-created-database-with-android/9109728#9109728 — Yaqub Ahmad, Apr 23 '12 at 11:50

score 1 · Accepted Answer · edited May 23 '17 at 11:49

1

Instead, you should put your database with a table (having 8000 records) inside the Assets folder and write a logic to Copy existing database inside your android app.

Check links:

edited May 23 '17 at 11:49

Community

1
1

answered Apr 23 '12 at 07:20

Paresh Mayani

127,700
71
241
295

The same logic is followed here: http://stackoverflow.com/questions/9109438/using-already-created-database-with-android/9109728#9109728 – Yaqub Ahmad Apr 23 '12 at 11:51

score 1 · Answer 2 · answered Apr 23 '12 at 07:20

1

What ever approach you conduct but do it in an SQLite Transaction because it will maintain a single Journal (db cache) file for inserting all the records in one go. It will really speed up things a lot.

answered Apr 23 '12 at 07:20

waqaslam

67,549
16
165
178

score 0 · Answer 3 · answered Apr 23 '12 at 07:22

0

If you have the .sql file you may import it in phpMyadmin.... Just go to PHPMyadmin URL... create an empty database.... click on import... Browse the sql file click on Go...

That's it

answered Apr 23 '12 at 07:22

Anwar

672
4
16

oh really?? Do you think this is a relevant answer? – Paresh Mayani Apr 23 '12 at 07:24

Create Sqlite database with 8000 records

3 Answers3