Version 3.1 supports "pragma auto_vacuum" as an alternative. 3.1 is currently still in alpha stage though.
http://www.sqlite.org/pragma.html#modify --- [EMAIL PROTECTED] wrote: > > > > Thanks. > I am not sure this is very useful, because it copies the database, which > requires that there be enough file space for a copy. > It would be nice if there was something that worked by truncating the file. > > Clive > > > > > > Dick Davies <[EMAIL PROTECTED]> on 01-02-2005 13:40:13 > > Please respond to Dick Davies <[EMAIL PROTECTED]> > > To: [email protected] > cc: (bcc: clive/Emultek) > > Subject: Re: [sqlite] Compacting a database > > > > * [EMAIL PROTECTED] <[EMAIL PROTECTED]> [0212 11:12]: > > > > > > > > Is there a way to compact a database after removing data? > > vacuum ? > > -- > 'One cannot make an omelette without breaking eggs -- > but it is amazing > how many eggs one can break without making a decent omelette.' > -- Charles P. Issawi > Rasputin :: Jack of All Trades - Master of Nuns > > > > > > > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail
