[email protected] wrote:
> > > >Marc, > > I see that you are processing 15 Alter commands on the same table. I believe >you would not > >only see disk space savings, but also considerable speed increase if you did >the processing > >on temp tables for your commands and then save to the permanent one. > > > >Something such as : > > > >Project temp temptab1 from travcard using all > > > >Alter Table temptab1...... > >Alter Table Temptab1..... > >(do all 15 of yoru alter commands to the temp table) > > > >Drop Table travcard > >Project travcard from temptab1 using all > > > >You should see most of your space consumption go away, AND you should see > >significantly faster speed, especially if this app is on a network as the temp >tables > >are handled locally and do not have the multiuser overhead. > > >-Bob > >----- Original Message ----- >From: "Emmitt Dove" <[email protected]> >To: "RBASE-L Mailing List" <[email protected]> >Sent: Wednesday, June 16, 2010 9:00:47 AM GMT -06:00 US/Canada Central >Subject: [RBASE-L] - Re: RB2 files quadruples in size? > > > > >Marc, > > > >That’s the way it is. Whenever you issue an ALTER TABLE command, R:BASE >renames the table, makes the change then, in effect, projects the result into >a new table. The original, renamed table is removed from the schema, but the >space it consumed remains consumed until you do a PACK or RELOAD. > > > >Do a LIST and note where your table falls in the list. Now do an ALTER TABLE >followed by another LIST. Unless your table was the last on the list to >begin, it will be elsewhere in the list. That is a visual clue as to what is >going on behind the scenes. > > > > >Emmitt Dove > >Manager, Converting Applications Development > >Evergreen Packaging, Inc. > >[email protected] > >(203) 214-5683 m > >(203) 643-8022 o > >(203) 643-8086 f > >[email protected] > > > > > >From: [email protected] [mailto:[email protected]] On Behalf Of MDRD >Sent: Wednesday, June 16, 2010 09:47 >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: RB2 files quadruples in size? > > > > > > > > >Larry > > > > > >What a mess! Unfortunately this is a permanent table with over 13,000 rows. >Such a simple change sure can cause major pains. > > > > > >Thanks for the tip > > >Marc > > > > > > > > > > > > > > >3. If this is permanent, prexisting data, make a temporary table with >different column names and the longer field sizes. Then append the data to >the temporary table, delete the data from the real table, do the ALTERs, and >append the data back from the temporary table to the real one. > > >-- > > >Larry > > > > > > > >From: MDRD <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Wed, June 16, 2010 8:48:30 AM >Subject: [RBASE-L] - RB2 files quadruples in size? > > >Hi > > > > > >The RB2 file went from about 200 megs to over 800 megs all of the sudden? > > > > > >It appears this block of code caused the problem, > > >My only guess is to put a Pack Table every so often to keep from hitting this >wall > > > > > >Thanks > > >Marc > > > > > > > > >-- there is only 300 rows in this table > > > CREATE INDEX v1 ON `spbutton` (`NewButName` ASC ) > CREATE INDEX v2 ON `spbutton` (`V2` ASC ) > CREATE INDEX v3 ON `spbutton` (`V3` ASC ) > CREATE INDEX v4 ON `spbutton` (`V4` ASC ) > > > > > >-- only 10-20 rows in this table the column was Text 50 > > >ALTER TABLE PopTCS ALTER PopTCSTxt TO PopTCSTxt TEXT 150 > > > > > >-- only 13,337 rows in this table the Text fields were 50 each > > >-- total row size after this is around 3021 > > >ALTER TABLE travcard ALTER Sympt1 TO Sympt1 TEXT 150 >ALTER TABLE travcard ALTER Sympt2 TO Sympt2 TEXT 150 >ALTER TABLE travcard ALTER Sympt3 TO Sympt3 TEXT 150 >ALTER TABLE travcard ALTER Sympt4 TO Sympt4 TEXT 150 >ALTER TABLE travcard ALTER Sympt5 TO Sympt5 TEXT 150 > > > > > >ALTER TABLE travcard ALTER Therapy1 TO Therapy1 TEXT 150 >ALTER TABLE travcard ALTER Therapy2 TO Therapy2 TEXT 150 >ALTER TABLE travcard ALTER Therapy3 TO Therapy3 TEXT 150 >ALTER TABLE travcard ALTER Therapy4 TO Therapy4 TEXT 150 >ALTER TABLE travcard ALTER Therapy5 TO Therapy5 TEXT 150 > > > > > >ALTER TABLE travcard ALTER Adj1 TO Adj1 TEXT 150 >ALTER TABLE travcard ALTER Adj2 TO Adj2 TEXT 150 >ALTER TABLE travcard ALTER Adj3 TO Adj3 TEXT 150 >ALTER TABLE travcard ALTER Adj4 TO Adj4 TEXT 150 >ALTER TABLE travcard ALTER Adj5 TO Adj5 TEXT 150 > > > > > > > >
