Tks, i’ii check.



De: Svein Erling Tysvær [mailto:svein.erling.tysvaer@...]
Enviada em: quarta-feira, 8 de setembro de 2010 04:02
Para: firebird-support@yahoogroups.com
Assunto: RE: [firebird-support] Problem Firebird - database database
exploded in size





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%40yahoogroups.com>
[mailto:firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com> ] On Behalf Of pecanha.luciano
Sent: 8. september 2010 03:10
To: firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.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





[Non-text portions of this message have been removed]