Hi, I have a long running multirow update such as: UPDATE T set C1 = calculation(C2) where C1 is NULL If table is large, this update may take many seconds or even minutes. During this time all other queries on this table fail with "database is locked" after connection timeout expires (currently my timeout is 5 seconds).
I would like to stop this update query after, say, 3 seconds, then restart it. Hopefully, after several restarts entire table will be updated. Another option is to stop this update query before making any other request (this will require inter-process cooperation, but it may be doable). But I cannot find a way to stop update query without rolling back all previously updated records. I tried calling interrupt and returning non-0 from progress_handler. Both these approaches abort the update command and roll back all the changes ( I know, this behavior is documented). If interrupt and progress_handler cannot help me, what else I can do? I also tried UPDATE with LIMIT and also WHERE custom_condition(C1). These approaches do allow me to terminate update earlier, but they are significantly slower than regular update and they cannot terminate the query at specific time (before another connection timeout expires). Any other ideas? Thank you _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
