Re: Advice on NT and ORACLE hardware

Nuno

Thanks for the tips. May I ask a few questions ?

snip

>
>Yup, shouldn't be a problem. Get big memory though, you'll need it.
>

Thinking of 1G. Is that enough ?

snip

>
>Hmmmmmm, probably yes but get ready for a big hardware budget. In this size
I'd
>be looking at UNIX straight away, NT is just not there (no pun intended!)
for
>these big sizes. For a number of reasons I'm not gonna bore you with, they
are
>available from somewhere else.
>I have 15 million rows on a table at work with UNIX. The hardware can do
queries
>on this in about 2 minutes, although not heaps of concurrent ones. And it
is a
>beefy UNIX box... So don't expect OLTP performance in your queries to this
>database unless you can afford heaps of CPU and memory to cache the thing.
>Resist the temptation to put everything on the single table, it won't work
in
>the long run.
>

The initial table will not contain more than 4,000,000 rows and any query will be against individual records in the table. We are basically fetching and replacing individual records. What sort of table size should we limit ourselves too do you think ?

As far as CPU is concerned we are initially putting in 2x450 Pentium but will move to cluster technology and parallel servers if need be.

Again thanks for the help

Cheers
Steve

p.s As far as Unix is concerned we don't have any experience in this area and are a little loath to bring in too much outside help. The development is being done in Scandinavia but the system will be delivered, administered and run in the Middle East. Received on Wed Dec 09 1998 - 09:31:20 CST