To: Michael G who wrote (8758 ) 1/14/1998 6:53:00 PM From: Mark Finger Read Replies (3) | Respond to of 14631
>>>> The NT/Intel boxes are really beginning to scale and in several >>>> years NT scalability shouldn't be an issue (compared to Unix). Watch out for the difference in capacity of the engines. Microsoft, Oracle, IFMX and Sybase all talk about terabyte databases. However, there is a major difference in capacity. MSFT 6.5 had a total database size limit of 200G. I understand this has been raised to 1T in 7.0. Now the problem if this is true is that there is typically a much lower "working" maximum for a DBMS. So the terabyte for Microsoft would appear to be more of an "absolute" maximum. On the other hand, the others have more of a working maximum. I have found the following numbers. Sybase 11.5 has a database size limit of 8T. IFMX 7.x has a 64T size limit on a table, and do not indicate the size limit for the database. I have heard the the database size limit of Oracle 8 is in the 50T range. Note that a university in New York is using IFMX as the basis for their research on petabyte (1000T) DBMS's, especially in data warehouse cases. NASA is building an application that they expect to be 5 petabytes in 5 years, and adding a terabyte PER DAY. This is being build on an IFMX database. When you look at it this way, it is clear that Microsoft is only slowly scaling. Note that the other Big 3 numbers are for shipping products, while Microsoft is still 6 months away from being able to handle more than 200G (current limit of 6.5), because all they have announced is a "beta" product. Remember that the big 3 have many deployments NOW larger than what Microsoft can even consider now, and even in the future. Mark