What to do? Many updates and selects

From: Thiko! <biwombi_at_hotmail.com>
Date: 2 Jun 2005 07:46:42 -0700
Message-ID: <1117723602.321680.234920@f14g2000cwb.googlegroups.com>

Scenario 1:

I am going to have a system where approx. 1000's of one line updates per second or one line selects per second can be expected on the oracle database software.

The best hardware for this I guess would be critical, e.g super fast disks, lots of cpu etc? Oracle will be on UNIX or Linux. Most likely for us Linux.

Scenario 2:

There will be 'users' doing these updates and selects on the database from a web site.
There will also be internal apps processing this data for other internal reasons.

Should separate database used? Perhaps a replicated database could be used for the internal apps and querying. The internal use is simply SELECTs for reads. Or, the web users/subscribers will use the same database as the internal apps. Pros/Cons? Im thinking the internal apps could run at night for their select data to be collected.

Many thanks for your help!

Thiko! Received on Thu Jun 02 2005 - 09:46:42 CDT