Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

Double Echo wrote:

> I couldn't agree more Daniel. My own experience has shown scalability
> to be a number one problem with SQL-Server. But the new features
> coming out in SS-2205 should not be ignored. There are improvements,
> and like other people I am waiting to see how it shakes out. You and
> I both know SQL-Server is not going away, if anything it is increasing
> its footprint by leaps and bounds. As a technologist, I am practically
> required to understand the product in order to make sure I understand
> it's usage in an environment, simply because of its pervasiveness,
> something even Oracle can't claim as much of--there will probably
> alway be orders of magnitude of MS-SQL compared to Oracle. That is
> largely in part because of marketing and branding of these products;
> Oracle pushing down from big shops into small shops, and MS-SQL pushing
> up from small shops into big shops. The collision, as we have seen
> in this thread is that thermocline that produces flame wars.

Yup, very well said. What I'm seeing here as well.

> Unfortunately businesses are doing just that, putting their mission
> critical data in SQL-Server, but you already knew that.

Indeed they are. I still think it's a major strategic error as well as tactical suicide. Diferentiation between businesses starts at how well each takes advantage of the information it needs to be successfull. Make processing that information into a single commodity style baseline and you got a recipe for very good bottom lines for a while and no competitiveness whatsoever in the medium term. Some businesses can afford that. Others won't. IME, size-related. But we'll see how things will pan out.

Hardware is not as critical as it used to be, neither is the OS. Things are different nowadays and maybe there is a business case for it being so. The other thing that folks should always be aware
of is that Windows ES is NOT the same as vanilla desktop Windows: the two are only common in name. ES is a well rounded OS, with some limitations for sure but quite usable for general purpose computing. Cheaper than *n*x? I don't think so, but there will always be an accountant that will disagree.

> a dependency on a db. Larry will be the first to tell us applications
> drive databases, not the other way around. And it is instructive for
> all of us to think first in terms of supporting businesses with good
> sound logic skills, and accept the fact that management does not always
> apply the same logic we do, if at all. Your skills should transcend
> product, plain and simple.

Well said.
(applause) Received on Thu Feb 23 2006 - 18:48:42 CST