Android: how cancel/interrupt/break pending SQLite query?
In my Android application user can fill database with imported data, then perform predefined, complex SQL query. With some data pattern, query will take very long (minutes and more on HTC Hero), while common usage will not exceed 10-15 seconds.
Is there any way to cancel pending SQLite query on Android? Timeout would be as good as well, partial results are not required. I'm performing query within开发者_如何学C AsyncTask.doInBackground()
I know best way is optimize query or change app logic, but in this case results depends on user knowledge anyway, so I'd like to help those who enter troublesome pattern.
You can't cancel pending sql query. It's done in SQLite engine. SQLite has native methods to interrupt query, but it's not accessible in java interface.
The best would be to improve query performance.
Read this: http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning
You can divide long running queries to smaller by limiting row number. Then it would be easier to cancel query that is performed in chunks.
ASyncTask supports cancellation and the flag should cancel all, including your SQL Query.
ASyncTask.cancel(boolean mayInterruptIfRunning)
SQLite provides a intrerupt method: http://www.sqlite.org/c3ref/interrupt.html
I'm not sure how you would call that in Android though.
You can cancel running queries on sqlite by using android.os.CancellationSignal
which can be passed to some of the methods of android.database.sqlite.SQLiteDatabase
精彩评论