You can't, the thread is down in the SQLite engine doing its work.

I would really look at why your queries are taking so long -- 30 seconds is
just insane.  For example, have you created indexes on the appropriate
columns for the query?

On Sat, Sep 26, 2009 at 9:16 AM, mjc147 <westmead...@yahoo.co.uk> wrote:

>
> How to programmatically stop a long-running query?
>
> The long-running step is, for example, the first call to
> Cursor.moveToFirst(). This can sometimes take up to 30 seconds so I
> would like the user to be able to cancel.
>
> However, how should this be done? I've tried closing the Cursor (in
> another thread) but all that happens is that the close() call takes as
> long as moveToFirst() and then terminates with the exception:
>
> java.lang.IllegalStateException: attempt to acquire a reference on a
> close SQLiteClosable
>
>
>
> >
>


-- 
Dianne Hackborn
Android framework engineer
hack...@android.com

Note: please don't send private questions to me, as I don't have time to
provide private support, and so won't reply to such e-mails.  All such
questions should be posted on public forums, where I and others can see and
answer them.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to