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
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
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?
* [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.'
--
Is there a way to compact a database after removing data?
Clive
5 matches
Mail list logo