Emmitt, I need clarification on this.
Are you saying that updating a table will drop utilization in rx2 from 98% to 39% without STATICDB on ? Or are you saying utilization will NOT drop if STATICDB is on ? In this particular database there are a lot of updates, appending data from one table to another, creating temp tables for searches and very little deleting of data. The rx2 file size is just 19MB when utilization is 100%. What concerns me is that whether or not staticdb is On or Off, there should NOT be such a dramatic drop in utilization. Do you have any recommendations for the above scenario ? Thanks, Bill -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Emmitt Dove Sent: Thursday, July 10, 2008 12:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Turbo V-8 Database Utilization Question Any number of activities can cause the utilization to drop. INSERTing rows should not - new rows get appended to the end of the file. UPDATEing rows can, especially if you have NOTE fields on the tables. Any use of CREATE TABLE and DROP TABLE, when not in STATICDB ON mode or using CREATE TEMPORARY TABLE, will cause the same issue I outlined previously. 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 12:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Turbo V-8 Database Utilization Question 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
