On Sat, Feb 20, 2010 at 10:09 PM, Simon <dbern...@noos.fr> wrote:
> I also can stop the process between any two calls to sqlite3_step, my issue
> is with the first one that (to me) does not seem interruptible.
>
> I just tried adding a call to CHECK_FOR_INTERRUPT just after "for(pc=p->pc;
> rc==SQLITE_OK; pc++){" (~line 52715 in the ammalgamation) in sqlite3VdbeExec.
>
> It now behaves to my satisfaction (I can interrupt my query in no time)
>
> So I guess my question now becomes: is it safe?
Can anyone answer this? I've just implemented something similar to
Simon's approach (but constrained to two threads), and trying to
interrupt FTS3 queries can bring my entire development machine to its
knees. So I suspect the code is not safe even as it stands!
Thanks,
Hamish
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
