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

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Tue, 14 Feb 2006 21:01:04 -0500
Message-ID: <45fgb7F6i60jU1@individual.net>

HansF wrote:
> On Tue, 14 Feb 2006 14:55:37 -0500, Serge Rielau wrote:
>
>

>>What MS SQL Server achieves with CLR

>
>
> I'm still trying to figure out why they call it 'CLR'. Isn't it
> 'Microsoft Specific Vendor Lock-in Runtime'?
>
> Please correct me - it seems that if you remove the Microsoft Specific
> part, it seems to become standard ADTs referenced by O'Neil and O'Neil in
> the mid/late 90s.
>

ADT as in abstract datatypes?
Not quite. As I understand it it's more a generic VM and JIT. Not that much different from what e.g. the IBM (and perhaps other) compilers do: Multiple frontend compilers share one backend compiler.

In MS' favor it is kind of neat to share the same infrastructure across any number of languages. By adding CLR support the choice of is irrelavant. C#, VB, .. take your pick.. all supported and compatible in on eshot.
I'm kind of waiting for some one to develop a PL/SQL front end for CLR. Would make my life easier ;-)

There have been open source implementations as well which port the concept to other OS (unlikely what MS intended I suppose ;-) so you can run C# or VB on Linux.
http://www.linuxworld.com.au/index.php/id;555610088;fp;2;fpid;37

By all means I've got no issue with CLR as such. It's the invasion of unqualified app developers onto the DB core that scares me.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Received on Tue Feb 14 2006 - 20:01:04 CST