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

Niall Litchfield wrote:

> "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.

Or a homework assignment where the object is to learn how to estimate requirements & not to spec a system that could actually be built. Received on Tue Jan 29 2002 - 16:27:40 CST