table size?

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

table size?

Post by Thunderstone »



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





User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

table size?

Post by Thunderstone »




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.




Post Reply