Re: 10,000 queries per second: Can it be done?

How many unique queries are there out of the 10,000 you have each second? I'm getting my application to store the data it gets back from the database in memory for a definable period, so it works like a cache. Repeated queries come from the applications memory istead of the db. Our application runs up to 100 faster compared to hitting the db each time. I've written it for ColdFusion - you're welcome to the code but I suspect you're using Perl or something.

Gary.

<uqmoore_at_my-deja.com> wrote in message news:8p86cm$ic6$1_at_nnrp1.deja.com...
> Hey folks,
>
> We have a fast cgi app that processes about 10,000 web requests a
> second. Right now, we include all of the data the app needs at runtime
> in the source code so that all the data remains in memory while the app
> runs (we use a binary tree data structure). We do this instead of
> reading data from a file or accessing a database because we believe this
> is faster. The problem is, there's a limit to how large our data can be
> before this whole thing stops working effectively.
>
> Could we use an Oracle solution for our problem? Can Oracle handle
> 10,000 relatively small queries per second? What type of hardware would
> be needed? We are also thinking about using dbm files but we'd prefer
> to use a database.
>
> Thanks in advance.
>
> QM
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Sep 07 2000 - 09:36:27 CDT