Re: Terabytes + database on NT

On Tue, 13 Mar 2001 17:27:46 +0000 (UTC), aminocha_at_herold.com ("Anurag Minocha") wrote:

>Hi,
>We are in the process of deciding the operating system to hold our database.
>It is expected that the database will be in Terabytes and will keep on
>growing at a very fast pace.
>
>Is NT the right o/s for this or we should move to unix. If unix then which
>flavor of Unix.
>
>I must tell you that the dataase will mainly consist of scanned images.
>Another solution which is possible to limit the size of the database is to
>store the path of the images in the database and store the images in the
>file system. In this way we can use NT, but I am not sure of the side
>effects of this.
>
>We are thinking of 8i or later.
>
>Please help.
>Thanks
>Anurag

With that much data, and the number of disks to support it (I'd be surprised if you end up with less than 30 to 50 disks, regardless of OS) you'll invariably run into NT's "all I/O on processor zero" bottleneck. Even the best raid config in the world can't get past this.

In the words of Niall, NT would be "A courageous decision".

Ask Sun, HP, IBM et.al. for terabyte Oracle db with imaging reference sites, and they can give you dozens (probably hundreds) - meaning you know that a solution built on this will work. Ask Microsoft, and I guarantee they won't be able to give you a single reference for such a site. (Even Oracle themselves might struggle to come up with one doing this on NT).

Just my 2¢

Ciao
Fuzzy
:-)   Received on Wed Mar 14 2001 - 16:26:54 CST