To: DownSouth who wrote (37463 ) 1/3/2001 1:02:38 PM From: Thomas Mercer-Hursh Respond to of 54805 I think that is one of the weakest cases for Gorilla-ness that I have ever seen. To be fair, it is an off-hand remark, not a hunt report, so there *could* be a lot more behind the statement than was reflected in the remark.First of all, MSFT's new Windows Data Center is capable of scaling to accommodate the throughput rates of an online database. Bill's Gang have made a lot of claims, but do you know of any really high end sites being run using it? Last I heard, there were still an embarrassing number of MSFT sites that deserved to have a "Sun Inside" label. To be sure, MSFT has pushed up the upper bound on which it is possible to think of using MSFT products, but I don't think it is mere conservatism that keeps the lion's share of serious sites still going with Unix (or mainframes!).Second of all, if one of us made such an unsubstantiated case, we would be pummeled by such words as "prosperous investing", "RTFM", "dd", etc. Like I said, it was not a Hunt report or even the main thrust of the discussion.Third of all, there are other ways to solve database throughput issues beside "loading the entire database into virtual memory". To be sure ... but they also involve scalability. Merely loading the whole database into RAM simply requires support for enough RAM to fit the database. Doing something efficient with it once there is quite another matter. I agree, loading the whole database into memory is simply one tactic and one that is only feasible with relatively limited databases and only really useful if there are very high transaction volumes against the whole of the database. If one has much larger database and/or only a fraction of the database is subject to large transaction volumes and/or there is a distributed nature to the application, then there are many other techniques to draw from which are both more cost effective and, in some cases, more overall effective, than sucking the whole thing into RAM.Would love to hear from you DBA's on this one. Not a DBA, but a designer of such applications...