[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solid
Subject:    Re: database increase so rapidly
From:       Tom <tom () sdf ! com>
Date:       1998-06-03 23:56:57
[Download RAW message or body]


On Tue, 2 Jun 1998, Alessandro Bonvicini wrote:

> Please,
> can someone explain me the following fact?
> I have a table of 10 Mb in solid server.
> The LogEnable is set to No.
> If I do "delete from table" the database size increase of the double, i.e.
> 20 Mb.

  When the database needs to expanded, Solid adds another "chunk".  The
size of that chunk is configurable in solid.ini

  However, many operations do require storage up to twice the size of the
original data.

> Then I do a checkpoint, but the size doesn't decrease.
> How can I free the disk space that solid server has now occupied ?

  The size can not be descreased, expect by a full dump and reload.

> Thank in advance
> Alex

Tom

[prev in list] [next in list] [prev in thread] [next in thread]