U could make once a year a back-up/restore an that wil solve your problem!
All procces will take no more that 5 minutes an 70 mb database!

Regards
Paul

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Arn
Sent: Friday, February 03, 2006 1:33 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Growing Database

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


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links