Defragmenting a local database

[Ruslan Zasukhin]

On 4/22/06 8:34 AM, "Brendan Murphy" <bmurf at comcast.net> wrote:

Hi Brendan,

> Using a single file local valentina database is it possible for
> the database to become fragmented?

yes

> If so, is it possible to
> defragment/compact a local database programmatically?

Yes, please look here

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:reference

 
> If not I would suggest a new feature that would allow me to detect
> the percentage of fragmentation and then allow me to defragment
> the database.

We already have such function in the engine, but it is not exposed.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]