Re: Very Large Database Support Inquiry...
Date: Wed, 25 Jan 1995 10:57:06
Message-ID: <finkel.123.0028083B_at_links.com>
HI Marc.
Based upon my experiences, I would agree with your summary of the products. To date, the vendors have not supplied me with any evidence that they can support databases the size that you are discussing. Performance of course is heavily dependent upon the nature of the queries but I have found that the databases do develop bottlenecks when scaling up. For example Oracle's very limited use of indexes within its parallel query mode at this time sometimes leads to situations where parallel query operations run slower than simple indexed operations - creating a very awkward performance tuning environment.
For the time being, the mainfame databases (DB2, Tandem, Teradata) seem the best suited for the size of databases that you are discussing - primarily because their architectures and optimizers are much more mature. This may change in the future.
Regards,
Rich
In article <D2vB5t.1x6_at_tfs.com> marcs_at_tfs.com (I am Marc E. Strohwig) writes:
>From: marcs_at_tfs.com (I am Marc E. Strohwig)
>Subject: Very Large Database Support Inquiry...
>Date: Mon, 23 Jan 1995 16:58:41 GMT
>Greeting,
> I'm try to locate some real world cases that have used one of
>the popular RDBMS products to manage Very Large Databases - on the
>order of 500 Gigabyte to 1 Terabyte. What I have on hear-say is that
>Oracle does a so-so job, Informix is supposed to do a good job but is
>too new and unproven and Sybase is pretty much unusable since it has
>some sort of problem scaling past 4-CPUs on an SMP system.
> Can anyone comment? Recommend?
> Thanx,
> _Marc
>--
>------------------------------------------------------------------------------
>Marc E. Strohwig Opinion? Mine, mine, mine!!
>System Architect
>SEI IS&S Compuserve: 70613.502
>TRW Financial Systems,Inc Internet: marcs_at_tfs.com
>Voice: (510) 645-3681 Former Address: marc_at_sybase.com
> FAX: (510) 645-3096
Richard Finkelstein
Performance Computing, Inc.
312-549-8325 (Voice)
312-549-4824 (Fax)
Received on Wed Jan 25 1995 - 10:57:06 CET