Re: 2tier 250users max?

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: Mon, 22 Nov 1999 22:32:39 GMT
Message-ID: <3839c2ef.1934091@newshost.interact.net.au>

On Mon, 22 Nov 1999 15:56:09 -0500, "r.golds" <r.golds_at_csdcsystems.com> wrote:

>We want to expand the number of users that can connect to our 4g Oracle
>database from 220 to 1500 concurrent. But we've been told that performance
>will just die at 250 users, and that the only solution is to go to 3tier.
>That is, at over 250 users, oracle's performance will die exponentially --
>so queries that take 2 seconds with 200 users will take 2 years. That sort
>of thing.
>
>It seems to me that a corresponding increase in hardware performance should
>support the increased usage. (ie 1500/220 = 7 times the processor
>performance).
>
>Agree? Disagree?
>
>What's the largest concurrent 2tier Oracle installation?

Whoever told you this doesn't have a clue.

I know of at least 3 sites with 3000+ users, 1100 of which are concurrent. They use our 2-tier product, and all the users connect to one Sun server. (OK, on one site the server's got six procs and two gig of RAM, but hey, we're talking 1100 concurrent users).

Ciao
Fuzzy
:-) Received on Mon Nov 22 1999 - 16:32:39 CST