insert 5000 records in sqlite?

Question

which is the best way to insert 5000 products(name and price) in sqlite? I try not to use 5000 inserts one below the other like that:

 db.execSQL("INSERT INTO " +tableprod+" (id_prod, name) VALUES (7791234567898, 'chocolate')");

Should I use json and gson and don't use sqlite?Thanks.

The data is supposed to be in the database or somewhere where the user can retrieve through the Id — Patricia Tapia, Mar 19 '18 at 23:58
You did not answer my question. Where do these values (`7791234567898`, `chocolate`) come from? — CL., Mar 20 '18 at 07:51

score 1 · Answer 1 · answered Mar 19 '18 at 00:15

Adding one by one would be slow. You can use Batch insert, using which you can insert all the 5000 records in just one transaction. Something like:

// Init SQLiteDatabase
database.beginTransaction();
// do ALL your inserts here
db.setTransactionSuccessful()
db.endTransaction();

Hope this helps.

1 Answers1