Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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...Received on Sat Feb 11 2006 - 14:56:22 CST
> 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