Prev: Business Intelligence extends Real Estate Reporting
Next: ASNCLP OFFLINE LOAD
From: Serge Rielau on 10 Aug 2010 02:09
On 8/9/2010 10:18 PM, Mark A wrote:
> "datenwort"<sebastian.saemisch(a)sowarent.de> wrote in message
> news:a3eab89a-ba2e-4e45-bad6-433920717e9a(a)f6g2000yqa.googlegroups.com...
>> hello,
>>
>> thanks for answering. why is java the worst case in developing user
>> defined functions? is there a benchmark or just own experience?
>>
>
> Partly because Java always runs as fenced mode, and partly for other
> reasons. The information was previously provided by IBM architects on this
> newsgroup, although it was specifically referring to Stored Procedures. If
> you go to Google groups you may be able find the old posts on this subject.
>
>
I'm actually presently preparing a deck called "versus" where I
investigate such questions.
SQL UDF actually are faster than C-UDF when they are just encapsulating
simple expression evaluation. That is because even an unfenced UDF
undergoes overhead. And of course a SQL UDF DB2's optimizer can understand.



--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

From: --CELKO-- on 10 Aug 2010 08:20
>> I'm actually presently preparing a deck called "versus" where I investigate such questions. SQL UDF actually are faster than C-UDF when they are just encapsulating simple expression evaluation. That is because even an unfenced UDF undergoes overhead. And of course a SQL UDF DB2's optimizer can understand. <<


Will you post the details somewhere or send me a copy?
From: Serge Rielau on 10 Aug 2010 11:23
On 8/10/2010 8:20 PM, --CELKO-- wrote:
>>> I'm actually presently preparing a deck called "versus" where I investigate such questions. SQL UDF actually are faster than C-UDF when they are just encapsulating simple expression evaluation. That is because even an unfenced UDF undergoes overhead. And of course a SQL UDF DB2's optimizer can understand.<<
> Will you post the details somewhere or send me a copy?
It will be presented at DB2 Aktuell in Germany in mid September and then
at IDUG in November.
Once it's completed I have no qualms distributing it to interested parties.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

First  |  Prev  | 
Pages: 1 2
Prev: Business Intelligence extends Real Estate Reporting
Next: ASNCLP OFFLINE LOAD