Subject Re: [firebird-support] Re: SS under Mandrake 10 - performance degradation
Author Jacqui Caren
Svein Erling Tysvær wrote:

> Has this anything to do with transactions? What if you commit (hard
> commit, not commitretaining) after 20 responses, does the degradation
> still occur? Check your OAT (oldest active transaction) and next
> transaction.

I am using perl - and in order to have a number of open statements, I
have/had ib_softcommit (DBD::InterBase driver enabled).

I switched this off and after a bit of fiddling get >20 resp/sec for
over 400. Looks like (soft) commit is/was the problem.

> Have you tested other operating systems, i.e. is the problem specific
> to SS under Mandrake 10, or is it just that Mandrake 10 and
> SuperServer is the only thing you have tested?

It is the target platform for the project :-)

Thanks for the prompt response.

Jacqui