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

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

It's possible, but there are a few factors involved.

1. Make sure your data is spread across multiple disks. In that way several queries can be processed simultaneously - look into the partitioning option. Your problem will not be a bottleneck in Oracle, but an I/O (disk) bottleneck.
2. If the size of the data you fetch from the database is small, let Oracle cache it. Allocate a large buffer pool, and issue "BUFFER_POOL_KEEP" on the table. I cannot remember the syntax off the top of my head, but it will force Oracle to keep the data from that table in the cache and never time it out (ofcourse updates are still 'write through').
3. Instead of 2) you can also write your own cache in your app, but why not let Oracle do the work :)

Hope this helps,
Brian

-- 
Brian Rasmusson, Bitberry Software
Makers of BitZipper, a Next Generation ZIP utility
br@bitberry.com - http://www.bitberry.com