Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

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

From: Tony Rogerson <tonyrogerson_at_sqlserverfaq.com>
Date: Sat, 11 Feb 2006 20:56:22 -0000
Message-ID: <dslj0v$5s6$1$8302bc10@news.demon.co.uk>


> 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
Received on Sat Feb 11 2006 - 14:56:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US