tornellas wrote:

> Hi People,
>
> This is my first participation here. So, excuse my poor English
> because I'm Brazilian and write and speak perfectly only in Portuguese. :)
>
> So, let's to the problem:
>
> Sometimes, when I get many connections (between 100 and 300), the
> server (php+iis+firebird 1.5.2) stays slow, very slow. The Server has
> 1GB RAM memory.

All on the same machine?
( With that volume, I'd be thinking of a separate machine for the database )
Which version of PHP?
( 5 is slower than 4 but has better Firebird driver )
What version of Windows? Do you need to use IIS, I've never bothered
with it, Apache2 on windows works fine for me.
Are all the Windows 'adjustments' in place ( using .fdb for database
extension )

> I know when I open connection the FB starts a transaction. That can
> cause the slowness in my server? (If I compare with DELPHI, it's
> strongly recomended to Start a transaction)
>
> It's always necessary to start a transaction with ibase_trans?

I use my own ibase_trans after opening the connection, so I know what
settings are being used. I'm not convinced on the 'default' transaction
and it has helped with a couple of niggles, but nothing speed related,
more to do with multiple people updating the same record.

Looking at task manager, which process is busiest when the system is slow?

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.