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
