Thanks Emmitt for your response on the first part of my question. I still don't understand why the utilization drops so drastically from daily use as I outlined below.
Bill -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Emmitt Dove Sent: Thursday, July 10, 2008 8:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Turbo V-8 Database Utilization Question Bill, Any time you add a column to a table, R:BASE creates a copy of the table with the new column and removes the original. (If you do a LIST before and after such an activity, you'll note that the table has moved in the table list.) That creates the unused space in file 2 that you are seeing. It is perfectly normal behavior. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Owens Sent: Thursday, July 10, 2008 10:00 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Turbo V-8 Database Utilization Question I have a V8 database I just reloaded. The file #2 utilization shows 100%. If I then add a column (text 8) to a table and do an autochk full the file #2 utilization falls to 78.329%. I have also noticed on the same database that after a few days of use on my network (There are only adds to tables, no deletes) the file #2 utilization falls dramatically (In 1 instance it fell to 39% from 98%) What causes this dramatic drop and how can I prevent it? Has anyone else noticed this situation? Bill
