Marc: After this piece of code is run, your database contains 15 (fifteen) temporary copies of the table TravCard.
What might help: 1. If this is transient data, make it a temporary table instead of a permanent one. The ALTERs will not then bloat the database. 2. If this is transient data, do the ALTERs before there's any data in the table. You'll still have 15 copies of the table, but they'll be copies of an empty table. 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
