Hi Everyone.

I have a dataabse that uses myisam tables. I have a C program that checks the file sizes of all the .MYD files to make sure the database doesn't get too large. When it reaches a certain size, the C program deletes (and summarizes) the earliest records until the database size is wihtin the limit. Problem is this: the file sizes don't get any smaller as I delete the records. They definietely get larger with each insertion, but even when I delete every record, the file sizes remain the same. Only when I do a total "DELETE FROM theTable" does the file size drop to zero. My thought was it had something to do with buffering or transactions or something, but myisam table are non-transactional. Any ideas people?

MAGICHANDSHAKE