Is there any possibility to insert bulk of records with in second in database in android?

Question

I want to insert 400 questions into database with in a second. Please let me know if any one knows the example or answer. Your help is much needed and appreciated. Thanks in advance....

Thank you, Krishna

Answer 1

Use a compiled statement.

How do I use prepared statements in SQlite in Android?

There's a helper class in android that you can use to make things a bit easier also. It's DatabaseUtils.InsertHelper and here is a good tutorial on how to use it.

Answer 2

Insert into the database in separate thread. Use prepared statements.