> I make a database, let's say the size is 300kb.I add thousands
> record, it resize
> to 1,5 MB. After deleting all the records the size still 1,5 MB.
> Well if it will
> be used by another record when i insert new records, i must check
> it then.
> Thanks Anyway.
>
> Budi
> Quoting Dan Wilson <dwilson@...>:

If you add 10,000 records the next time, it will grow to accommodate these
10,000 records. You then delete them all and next time insert 2,000 records.
It will now be the same size as it was after the 10,000 record insert
operation. It will always relfect the largest space you have required. This
is called dynamic resizing. If you used to work with early version of MSSQL,
then you would know that this was a nightmare early on since admins used to
watch carefully the MSSQL database and allocate the max size expected and
always increment the db size if they saw it reaching it's max size. IB
always OTOH had dynamic resizing which was a part of the deploy and forget
marketing
Alan