On 11 Oct 2010, at 10:56am, Michele Pradella wrote: > I know that in this use case UPDATE is lither than DELETE, but if I > make a DELETE at 4am I can have the DB locked for a lot of time at 4am: > I'm only shift the problem. > It's not a problem of interface efficiency for user experience: the goal > is to make the system always reactive without slow down all the other DB > operation.
Then delete the records immediately. Don't wait for a batch to build up. Delete some every minute. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users