> Hi all,
>
> While browsing the knowledge base on ibphoenix I came across a
> Code-Sample in C on how to connect to Firebird/Interbase with garbage
> collection disabled.
> The Code-Sample was for InterBase 5.
> Does it still make sense for FB1.5?
>
> I'm asking because I experienced performance problems (occasional hangs
> from 8-24 seconds) with Firebird and PHP under heavy load.
> I suspect Firebird to be garbage collecting during these hangs, and thus
> not answering to any queries.
>
> Would it help using connections with garbage collection disabled?
>
> Regards,
> Thomas

I assume you mean php on a website and not via a script exec? I can't really
believe that this hanging behaviour has anything to do with garbage
collection. Think for a moment about the nature of transactions in this
environment. The transactions are numerous but they so short that OATs would
roll on without much hindrance. And how much use of rollback would there be?
not much either I suspect. In this environment garbage collection would
seldom if ever be running.

In any case what is your setting? 20,000? and how frequently are your
"hangs"? Does this marry?

Alan