It's what I'm doing: I'm deleting every 15 minutes of a small number of records at a time.
Il 11/10/2010 12.40, Simon Slavin ha scritto: > 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 > > -- Selea s.r.l. Michele Pradella R&D SELEA s.r.l. Via Aldo Moro 69 Italy - 46019 Cicognara (MN) Tel +39 0375 889091 Fax +39 0375 889080 *michele.prade...@selea.com* <mailto:michele.prade...@selea.com> *http://www.selea.com* _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
