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

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Fri, 17 Feb 2006 18:25:41 -0800
Message-ID: <43F685A5.10405@comcast.net>

Galen Boyer wrote:

>>
>>Does work though and scales.

>
>
> As long as one is congnizant of the resources being used and coding
> accordingly.
>
>

This one of the differences between Oracle and SQLServer. With Oracle, a coder does not have to be _as_ aware as to how to mitigate any limitations of the database server. They can do what they are good at - write business code. Let the database sort out transactions, isolation, concurrency problems etc.

SQLServer is much more demanding on coders. Coders need to know how to write business code, and also how to write this code to avoid isolation problems, deadlocks etc. Note that Tony, both as a SQLServer MVP, and a consultant, presumably makes a healthy living from having this required knowledge. Received on Fri Feb 17 2006 - 20:25:41 CST