View Single Post
  #1  
Old 03-04-2008, 12:38 PM
Jon Polish Jon Polish is online now
Registered User
 
Join Date: 07-21-2006
Posts: 391
Deleting large numbers of items

One of my databases is very close to 10GB. I have chosen to prune it and to my surprise the size did not decrease by the expected amount. I am using the beta (3.5) and have never done this size operation before, so I cannot be sure if it is a beta issue.

I deleted (Shift-Del) about 75% of the entries after transferring them to a new database for archiving (man, I WISH we could search across databases!). The recycle bin is empty and when I noticed the size (9.4GB), I compacted it. The size was about the same. I repaired the file using the database repair tool with the same result.

Are all the keywords retained in the database? Could that be what is causing the bloat?

Jon

Last edited by Jon Polish; 03-04-2008 at 12:45 PM.
Reply With Quote