Re: Hardware for 50 million record per year???

Sauron wrote:

> Hi there!
>
> I have not experiance with huge number of data.
> I need hardware for real time aplication, production, cca 50 million
> records per year in 1 table, many insert record. (cca 5-10 per sec)
>
> I look at some cluster (HP Proliant DL380 Packaged Cluster), 2x2 Xeon,
> maybe with 4GB RAM ?? Is it enough for thaz number of inserts??
>
> It must be HA, so I think RAC on that cluster, and maybe standby
> database on third server for reports (or can that cluster handle all
> inserts and reports??? - with Materialized Views maybe??)
>
>
> tnx for help

Based on what you've written I could do it on my notebook.

I would think any decent 2CPU Dell or HP/Compaq machine running Linux would be overkill.

BTW: I have hardware that has handled 20,000 inserts per minute so you are nowhere near describing a large number of transactions.

RAC might be of value ... but I wouldn't recommend it without first testing cache fusion block sharing.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)