table size?

Post by **Thunderstone** » Fri Aug 28, 1998 12:10 pm

Hi there,

I recently deleted a substantial number of records from our "html" and
"refs" table. The question I have is this: I don't believe the size (MB's)
of the tables was reduced, even though the records were removed. Is this
appropriate table behavior? How can or when will the tables be compacted?

I also deleted all records from the "todo" table -- same behavior occurred.

appreciated,
David Repas

SoundMarket -- where country clicks
@ http://soundmarket.net

Post by **Thunderstone** » Fri Aug 28, 1998 12:22 pm

Tables never shrink, but the space free'd as a result of a delete
will be reused by subsequent insert operations.

Many operating systems do not have the ability to reduce the size of
a file without removal/re-creation . This is a side-effect of that
behavior.