Subject Re: firebird performance - help
Author Svein Erling Tysvær
What are you doing to make the database grow from 5M to 320M? Even
though 320M is not very big, I get suspicious when things not only
double, but gets 64 times as big. Of course, it may be OK in some
special circumstances, but to me it sounds like you have lost control
over one or more transactions. Do you always ascertain that
transactions are short? Is there one long-running transaction being up
all the time? Do you use AutoCommit rather than Commit? The answers to
these three questions should be 'Yes', 'No' and 'No'.


--- In, "cosamektoo" wrote:
> Hi
> I'm using firebird 1.5 on solaris on intel.
> My application use among other things,sampling tables in which data
> is inserted and deleted from all the time.
> When my database file becomes large(say 320M) all the transactions
> are slower.
> If I backup and restore the database, the file becomes much
> smaller(say 5M) and the transactions are fast again.
> I can not backup and restore the database on a regullar basis since
> my server needs to be online all the time.
> Any suggestions ?