Thread: Database Bloat?
View Single Post
rob
Senior Member
Lone Wolf Staff
 
Join Date: May 2005
Posts: 8,232

Old January 15th, 2017, 05:19 AM
This is normal. Database engines typically behave this way. The data has been deleted within the database, but the file size is not shrunk. Once the database adds to its tables, it's both expensive and inefficient to delete that enlarged storage. Instead, the individual records are deleted, and the database stays the larger size. The next time that new records are written, they will simply reuse the internal space that's been freed up. So the database won't grow again for awhile, even if you add more material to it. The freed space will be reclaimed for use again.

Hope this helps!
rob is offline   #2 Reply With Quote