Should I excute Insert, Delete, Update on my own SQLite DB inside AsyncTaskLoader

Question

I read many posts telling long operations (like reading DB) should not be excuted on the main Thread.

So far I used CursorLoader (for "reading" ContentResolver) andAsynkTaskLoader(for "reading" my own SQLite DB).

I know to perform Insert, Delete and Update "on" ContentResolver I can use AsyncQueryHandler.

My question is: what's the best way to execute Insert, Delete and Update on my own SQLite db??

Should I simply execute those operations inside the method loadInBackground() of AsyncTaskLoader?

Thank you

Use `AsyncTask` and execute updates in `doInBackground` method. But, if your updates light and fast you can freely execute them in the UI thread and make your life a bit easier. — Dusan, Aug 25 '17 at 12:33
Even slow devices are capable of performing couple of hundreds of simple db operations per second, so there is no point to do single or few operations in the background. https://stackoverflow.com/questions/28188164/android-sqlite-performance — Dusan, Aug 25 '17 at 12:39

score 1 · Answer 1 · answered Aug 25 '17 at 12:42

1

If your queries are simple and it won't make much time to execute then simply you can use it in main thread itself.

If you're doing big data process then you have two options.

AsyncTask:

If you want to update your UI after an operation, you can use AsyncTask to do the process in a background thread and pass the result into the main thread. for more info about AsyncTaksk click here.

2.Thread

If there is no purpose of updating UI after the operation you can simply use Thread to do it.

answered Aug 25 '17 at 12:42

Bhuvanesh BS

13,474
12
40
66

Thank you man. What is evaluated ad a "big data process" for a mobile? saving/deleting/updating 100 records? 1.000? 1000.000? – MDP Aug 25 '17 at 13:39
1

I won't use main thread if i need to query more than 20 records. – Bhuvanesh BS Aug 25 '17 at 13:46
1

I don't know the exact numbers. But it's not about numbers, its about execution time. – Bhuvanesh BS Aug 25 '17 at 13:47
Thank you again :) – MDP Aug 25 '17 at 13:48

score 1 · Answer 2 · answered Aug 25 '17 at 13:00

You can use background handler thread for your purpose.

private Handler mHandler = null;  // global variable
private HandlerThread mHandlerThread = null; // global variable

// Create instance inside onCreate() or another place inside your code so it would be called one's. Also you can make it singleton if required but it's not the right way.

    mHandlerThread = new HandlerThread("HandlerThread");
    mHandlerThread.start();
    mHandler = new Handler(mHandlerThread.getLooper());

// perform background operation like :

handler.postDelayed(new Runnable() {
                    @Override
                    public void run() {
                       // Do background work here.

                   }
                }, 2000);

Should I excute Insert, Delete, Update on my own SQLite DB inside AsyncTaskLoader

2 Answers2