Bill, When you add rows to a table and the row to be added exceeds the size of block of storage allocated to that table RBase will Add the row by acquiring a complete block of disk space. Off the top of my head I don't recall what the .RB2 block size is. Also, to the best of my knowledge tables don't share blocks. So when you update and there are no variable length fields i.e. NOTE the update should be done in place. When you delete a row it is merely flagged and .RB2 size does not change. If you insert a row whether the .RB2 size changes depends on available space in the table block.
Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Thu, 7/10/08, Bill Owens <[EMAIL PROTECTED]> wrote: > From: Bill Owens <[EMAIL PROTECTED]> > Subject: [RBASE-L] - RE: Turbo V-8 Database Utilization Question > To: "RBASE-L Mailing List" <[email protected]> > Date: Thursday, July 10, 2008, 11:30 AM > 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
