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

Reply via email to