Re: 9i server performance, 5 million hits per second?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 29 Jan 2002 21:59:04 +0000 (UTC)
Message-ID: <a375v8$oo7$1@paris.btinternet.com>

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3C570550.692C_at_yahoo.com...
> chris wrote:
> >
> > Hi folks,
> >
> > I'm trying to get an idea on the performance of Oracle, or what might
> > be required to get a performance in the region of 5 million queries
> > per second, say simple select queries on an indexed table.
<snip>
> Putting databases aside for a moment, I would doubt that even plain ol'
> memory could spit out reads at 5,000,000 per sec. Which means that if
> you can find a system that can read from memory at 'n' ops per second,
> you are going to need 5,000,000 / 'n' machines (and a perfect and
> balanced app) to support this...
>
> Could be a struggle...

Mind you I'd like to see the system that could queue those 5million requests per second for the app and db to deal with.

In short I think this question shows all the signs of a systems requirements spec as drafted by management consultants.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue Jan 29 2002 - 15:59:04 CST