From: Aaron Held <aaron@me...> - 2001-09-26 18:39:47
This is one of those nebulous questions that usually get answered with another question but here goes
Does anyone have any memory usage statistics for working with COM and large recordsets? I need to pull about 1Meg from a DB server
and create an Excel document. I don't have the data or the Excel doc details yet but the client wants some HW estimate.
Client: What are the HW specs for the server?
Me: How many concurrent users do you expect?
Me: How many simultaneous users do you expect?
Client: all of them?
Me: How many clients to you have?
Client: 5-10 will be using the system initially.
Me: no problem ok
Client: But each customer can have up 6,000 users
And so it went.
As Isaac Newton would say now:
If I see further than others, it is because I stand on
the shoulders of giants too dumb to patent their discoveries.
(Gregory Palast, http://www.observer.co.uk/ )
From: Clark C . Evans <cce@cl...> - 2001-09-27 12:40:45
On Wed, Sep 26, 2001 at 02:41:33PM -0400, Aaron Held wrote:
| This is one of those nebulous questions that usually
| get answered with another question but here goes anyway.
Here is the chart I give my customers.
|Peak Usage | Calculated
Number of |Frequency | Number of | Hardware | Est.
People Using |of System | Concurrent | Requirement | Cost
the System |Requests | Requests(1)| |
20 people |4x per hour|20*4/60 = 2 | 128MB+20G+500MHZ |$400.00
20 people |20x per hr |400/60 = 7 | 256MB+20G+650MHZ |$450.00
20 people |60x per hr |20 per min | 512MB+20G+850MHZ |$500.00
50 people |4x per hour| ...
You need to then fill in the chart. My chart also has another
column called estimated bandwith... which is used to compute
the size of the pipe.
Now... I actually don't have good numbers for this as I'm
new to the whole game. Does anyone have a spreadsheet
with realistic numbers? I know it varies per application...
but with a few settings at the top of the spreadsheet like
(cycles per request) and (cycles per second). One could
come up with a useful tool. The first number is a factor
of applicaiton complexity, and the second is a factor of