Hi,

We are putting a proposal together for quite a large site and was wondering
whether there are any specific guidelines for memory requirements of a
server according to number of user sessions.  If for example, there are 100
users making requests at the same time (ie combination of web-browser
requests and windows-base client requests), would we need X amount of
memory.  And if 200 users X x 2.  Just looking for guidance to put in a
proposal.

Regards

Alex

Alex,

<< We are putting a proposal together for quite a large site and was
wondering whether there are any specific guidelines for memory requirements
of a server according to number of user sessions.  If for example, there are
100
users making requests at the same time (ie combination of web-browser
requests and windows-base client requests), would we need X amount of
memory.  And if 200 users X x 2.  Just looking for guidance to put in a
proposal. >>

For each physical table open per session, use:

98304 bytes if the table doesn't have any BLOB fields

and

131072 bytes if the table does have BLOB fields.

So, 100 sessions X 30 open tables (no BLOBs) per session would be
294,912,000 bytes, or 300MB or so.  Of course, that is just the buffering
sizes for the table data, so you should allocate a bit more for the
miscellaneous memory allocations.  So 512MB should cover it, but the more
memory, the merrier.

--
Tim Young
Elevate Software
www.elevatesoft.com