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

From: paul c <toledobythesea_at_oohay.ac>
Date: Thu, 23 Feb 2006 01:55:40 GMT
Message-ID: <wC8Lf.63941$B94.29292@pd7tw3no>

Joel Garry wrote:
> Tony Rogerson wrote:
>

>>Guys, I simple corrected Joel or whomever it was on their original post and
>>its gone from there, for each myth posted about SQL Server 2005 I've
>>responded and kept responding, its not me driving this - its you guys!

>
>
> You mean where I said "So that's an average of 2TB/week. Do you really
> defend what Tony said:
> Windows/pair of SATA drives can do that? "
>
> Or where I said "Well, here's where I disagree. The design necessary
> to get SQL Server
> to handle TB's of data along with random transactional queries puts the
>
> onus on programmers to do it right. All you need is one newbie and you
>
> are screwed. Unless you use the new feature that makes it work like
> Oracle. So let's see: New unproven feature or risk of manual error.
> New unproven feature or risk of manual error. New unproven feature
> that probably has bugs (like with ALL vendor databases new features),
> or near-100% chance of manual error. ...

World seems full of people, not mentioning numbers, who throw quantities around without specifying them. A week's got 168 hours in it, that's a lot of disks in a year unless you own a disk company, or spend half your time deleting instead of querying.

Apologies for not paying attention to all the details, even if being a half-assed assembler programmer, I think I can see the big picture in this particular case. *

I guess the phrase 'recorded history' has changed since Einstein's day.

Walmart won't last if they persist with their drill-down dogma, but if they want my advice in the meantime, I'll take their money but freely tell them they are wasting their lives.

One point in favour of all this history is that the big-time gigantic systems have always been proved in the field, not in the lab.

> I'll pass.

I'm with you.

ps: looking forward to watching the great innovators and artists of modern hockey. Too bad there isn't a Fabian P to pronounce on what really goes on in that game. Received on Wed Feb 22 2006 - 19:55:40 CST