On Fri, Oct 8, 2010 at 9:49 AM, Simon Slavin <[email protected]> wrote: > > On 8 Oct 2010, at 5:48pm, Stephan Wehner wrote: > >> On Fri, Oct 8, 2010 at 7:14 AM, Michele Pradella >> <[email protected]> wrote: >>> "science fiction?" was a rhetorically question. I'm only wondering >>> about what is the best and fastest way to DELETE a lot of records from >>> huge DB. I know and understand physical limit of data moving: anyway for >>> now I'm trying to split the BIG DELETE in some smaller DELETE to spread >>> the time used. It's the only way I can figure out at the moment. >> >> Is a soft-delete faster? Then you could add a slow-moving delete >> (mentioned earlier by Aldes Rossi, for example) >> for the soft-deleted records. > > Soft-delete ? Is that having another column which is a '1' if the record is > supposed to exist and a '0' if it's supposed to be deleted ? >
Yes, that's what I meant. Usually call the column 'deleted'; 1 means deleted, 0 means not-deleted. Stephan > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http://loggingit.com -> http://www.thrackle.org -> http://www.buckmaster.ca -> http://www.trafficlife.com -> http://stephansmap.org -- http://blog.stephansmap.org -> http://twitter.com/stephanwehner / @stephanwehner _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
