Database and removal of objects

[ConvertFromOldNGs]

by MichaelHill >> Wed, 13 Mar 2002 2:39:27 GMT

Afternoon All,

I have a query.

We have an Events database which has an Archive option. When we archive events we also remove them from the database. What we have noticed is that the database file grows in size which would lead me to believe that when adding new events it doesn't add them to the spaces that have been created but rather appends them to the end of the database.

Is this assumption correct? If not is someone able to explain what happens.

If it is correct is the only way of reclaiming free space in the database by shutting everything down and running the compact utility?

Thanks for the help.

Michael Hill
Gallagher's Group Ltd

[ConvertFromOldNGs]

by cnwdad1 >> Wed, 13 Mar 2002 2:51:43 GMT

Michael,

Check out the Installation and Administration Guide, specifically the SpaceReuseOption in the Persistent Database (PersistentDb) section of the initialization file.

regards,
darrell.

[ConvertFromOldNGs]

by gjoyce >> Wed, 13 Mar 2002 2:58:46 GMT

Take a look at the "SpaceReuseOption" parameter in the Jade .ini file

Graeme