Deepak Gupta wrote:

> Thanx Smith,
>
> As you wrote that sweep removes unneeded records and that space is used for newly inserted records.
>
> but in my case after calling sweep when i insert new record in database, database size is still increasing and I think it is just becouse of that data is not inserted on free memory blocks that freed by sweep.
>
> please answer.
>
> Thanx.
>
> Regards
> Deepak Gupta
>

Deepak,

This is a bit more complex than what I wrote, I suggest you to search
the archives for a more detailed explanation.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br