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

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Tue, 14 Feb 2006 06:39:23 -0800
Message-ID: <43F1EB9B.1010000@comcast.net>

>
> Does Oracle have the ability to create UDT's or UDF's using CLR? Can you
> index them?
>

On Windows platforms, you can create CLR UDF's in Oracle (or at least the Oracle equivalent of UDF's). In theory you could index them, as they are exposed as a function call, and you can create an index on a function (albeit with the same deterministic rules etc as MS SQLServer).

They will be slowish however, as each call to the function is an extproc. Using a CLR function would also prevent any migration of the database to a non Windows platform (at least, the function would need to be re-written into a portable language). Received on Tue Feb 14 2006 - 08:39:23 CST