Hi Helen,

I am glad you answered. I love your book.

The app is basically receiving data through HTTP->APache->PHP
PHP then connects to Firebird and pumps data through
stored procedures.

My Server is:
2x Opteron 248
4 GB RAM
SATA drives.
Win 2k Server SP4

The Firebird Server (SS) never takes more than ~140MB of RAM,
or so windows is reporting.

My app takes ~10MB per connection so 10*200 = 2GB

And Windows always shows 1GB+ Free Physical Memory.

You mentioned some Firebird objects:
the lock table
the undo logs for inserts
transaction log there in RAM, too,

Will these show as part of the Firebird server process in terms
of memory usage?

I will check the dead open socket situation tommorow.

About Classic mode:
I get way more "deadlocks" with classic than with super,
It is way slower because of all the Disk I/O and
I need twice the ram to support this many connections comfortably.

I am planning to try to generate a dump and submit a bug report.

what is the best way to do this on windows?

thanks for you help,

anything else you could thing of?

thanks,

stan