Charlie, I see that you haven't gotten an answer to your questions. TO the best of my knowledge when you SCONNECT/SATTACH tables from another database you should see minimal size changes in RB2,RB3,RB4 files. Each attached table will generate TABLE, COLUMN, INDEX records and SERVER table records in the RB1 file.
Go to www.rsyntax.com and check out the "SATTACH TEMPORARY tablename AS... syntax. This should also decrease the number of records added to the RB1 file. You might also review your code to determine if you are INSERTING then DELETING records from the SATTACHED tables. This would increase the size of the original table. Have you experimented with the PACK command to recover space. --- Charles Parks <[EMAIL PROTECTED]> wrote: > I have one database that is about 70,000,000 bytes but when I > sconnect another database which is about 67,000,000 bytes the > database grows in size to 175,000,000 bytes. After > sdisconnecting the other database this database stays inflated > in size even after a reload. > > The only way to get the size down is to > 1. unload the structure to a file > 2. the data to another > 3. split the structure file in half. > 4. Run structure file 1 > 5. run the data file > 6. run structure file 2 > > Is this a normal behavior or does the huge size increase mean > that I should be looking for something in one of the > databases? > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
