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

> Well - Oracle also supports CLR in the database as well. However the
> ability to extend a database with stored procedures etc written in CLR,
> Java or even a database's own data processing language does not equate to
> the ability to add new features to the database.

In SQL Server its in-process so performs better, in Oracle and DB2 its out of process and they both have their limitations.

In SQL Server you can write, User Definied - Types, Functions, Aggregates, Stored Procedures, Triggers within CLR, so its not just stored procedures; so, yes - you can add new features to the database; if I want to write a regurlar expression function that can be used anywhere within SQL Server I can write it in CLR and call it anywhere I can use a built-in system function.

-- 
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"Mark Townsend" <markbtownsend_at_comcast.net> wrote in message 
news:43EE4619.3070100_at_comcast.net...


> Tony Rogerson wrote:

>>>I agree there are people who are blind and can't see sqlserver will

>>>not have the same set of features as Oracle in even a hundred years

>>

>>

>> Does it need it? SQL Server has CLR which means it can be expanded 

>> infinitely.

>>

>

> Well -  Oracle also supports CLR in the database as well. However the 

> ability to extend a database with stored procedures etc written in CLR, 

> Java or even a database's own data processing language does not equate to 

> the ability to add new features to the database.

>

> But I suspect that you knew that and are just being ornery