Subject | Growing Database |
---|---|
Author | Arn |
Post date | 2006-02-03T11:33:21Z |
Hi All.
Scenario:
Done some calculations
Insert the results in a table, let say TableA
Take some of these results and put them in another table. TableB
Empty TableA.
All fine, but... database GROWS from 7 Mega to 77 or more.
Consider I must elaborate circa 60 years
1 year take 70 mega..............................
Commit every calculation don't work.
After backup restore all return normal.
Any hint to avoid growing?
TIA
Arn
Scenario:
Done some calculations
Insert the results in a table, let say TableA
Take some of these results and put them in another table. TableB
Empty TableA.
All fine, but... database GROWS from 7 Mega to 77 or more.
Consider I must elaborate circa 60 years
1 year take 70 mega..............................
Commit every calculation don't work.
After backup restore all return normal.
Any hint to avoid growing?
TIA
Arn