From: Aaron H. <aa...@me...> - 2001-09-26 18:39:47
|
This is one of those nebulous questions that usually get answered with another question but here goes anyway. 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? Client: Huh? 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. Any ideas? Thanks, -Aaron =================================================================== 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 . E. <cc...@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 the hardware... Best, Clark |