I think you can get into this situation in older Firebird versions (probably in 1.5.3) by writing

INSERT INTO TableA
SELECT * FROM TableA

without a proper WHERE clause (at least I think I did something like that once...).

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of pecanha.luciano
Sent: 8. september 2010 03:10
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Problem Firebird - database database exploded in size

Hi,
Dear support firbird
I had a problem with a database, it went from 600mb to 18GB in a matter of minutes, i find corruption in a table with more than 66.000 records.
My question is why the database has become so big? Which leads the database to get this size? and what can I do to not happen again?

Config: Firebird version 1.5.3 - application written in Delphi 2007 - windows 2000 server - using BDE 5.2mais or less 20 concurrent users - workstation windows xp / vista

Thank you very much
Luciano Peçanha