SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Technology Stocks : Oracle Corporation (ORCL)
ORCL 184.66-3.4%10:37 AM EST

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Muthusamy SELVARAJU who wrote (412)11/13/1996 6:16:00 PM
From: Mark Finger   of 19080
 
You have brought up a very complex field of discussion, but did not provide some required parameters.

1. What is the type of application? OLTP, OLAP, other?
2. How many users?
3. How much data?
4. Other needed features? Replication (how many sites)?

In some cases, there are limits to capacity. For example, SQL Server has a 200M limit in its version 6.5 and this will not be increased before next summer.

Red Brick is primarily suited for data warehousing (a form of OLAP) and is considered unsuitable for OLTP. On the otherhand, Microsoft is just starting to implement features needed for data warehousing.

Other questions are related to the OS? NT 3.51 was known to have virtual memory performance problems above 250M or so. Support for number of processors was limited to 4 (although some OEM's did more). These limited capacity of NT, and cause it to be considered for "departmental" level DB's. NT 4.0 is supposed to resolve some of these problems but is to new to have a lot of data from the field.

By the way, do not leave out Informix, which has faster benchmarks than Microsoft on NT and Oracle on Unix in same machine OLTP benchmarks from TPC.

Another situation at the high end (where Microsoft cannot yet compete) is that the hardware can make a lot of difference. The simple way that the machine is designed (especially in the case of clusters or MPP) can interact with the RDBMS to make wide differences on different platforms.

In other words, there are no simple answers for your question.
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext