How do I avoid freezing UI in Android when Inserting into SQLite DB in Intent Service?

Question

I am inserting a large number of items(~200) into an SQLite DB in an intent service's onHandleIntent in an android application, but the UI freezes and I get an Application Not Responding. To the best of my knowledge, an IntentService's onHandleIntent runs in a worker thread, so I don't understand why this is happening. How do I avoid this? Btw, the application works fine when adding a few items(~5)

Answer 1

Maybe you can use transactions for optimization.

Help link:https://www.tutorialspoint.com/sqlite/sqlite_transactions.htm

Answer 2

Try to use AsyncTask Class. Developer Docs are here