Re: [sqlite] Compacting a database

2005-02-01 Thread [EMAIL PROTECTED]
Hi ! An interesting enchantment may be (if anyone development that) an "VACUUM INFILE" method. That is (when many pages are unuseable (free) in db) a "pragma signed" transaction. If flag is -1, the db engine is use the last, and nearly to last pages. When flag is 1, the engine is use first, and

Re: [sqlite] Compacting a database

2005-02-01 Thread Dan Kennedy
lt;[EMAIL PROTECTED]> > > To: sqlite-users@sqlite.org > cc:(bcc: clive/Emultek) > > Subject: Re: [sqlite] Compacting a database > > > > * [EMAIL PROTECTED] <[EMAIL PROTECTED]> [0212 11:12]: > > > > > > > > Is

Re: [sqlite] Compacting a database

2005-02-01 Thread clive
espond to Dick Davies <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org 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?

Re: [sqlite] Compacting a database

2005-02-01 Thread Dick Davies
* [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.' --

[sqlite] Compacting a database

2005-02-01 Thread clive
Is there a way to compact a database after removing data? Clive