Prev: Business Intelligence extends Real Estate Reporting
Next: ASNCLP OFFLINE LOAD
From: datenwort on 9 Aug 2010 01:00
hello,

i try to implement some methods in udf for db2 (no specific platform).
now i am unsure if it would be better using c or java as programming
language. is there a benchmark for getting information about the
performance using these languages or a comparison?

thanks and regards
From: Mark A on 9 Aug 2010 08:47
"datenwort" <sebastian.saemisch(a)sowarent.de> wrote in message
news:87615d9a-ea60-48d7-b122-b3f8fe415b08(a)d17g2000yqb.googlegroups.com...
> hello,
>
> i try to implement some methods in udf for db2 (no specific platform).
> now i am unsure if it would be better using c or java as programming
> language. is there a benchmark for getting information about the
> performance using these languages or a comparison?
>
> thanks and regards

C Not Fenced is the best (but you must make sure they are thread safe our
you could bring down DB2.
Java is the worst (always fenced).
SQL is in-between.


From: datenwort on 9 Aug 2010 10:10
hello,

thanks for answering. why is java the worst case in developing user
defined functions? is there a benchmark or just own experience?

On 9 Aug., 14:47, "Mark A" <no...(a)nowhere.com> wrote:
> "datenwort" <sebastian.saemi...(a)sowarent.de> wrote in message
>
> news:87615d9a-ea60-48d7-b122-b3f8fe415b08(a)d17g2000yqb.googlegroups.com...
>
> > hello,
>
> > i try to implement some methods in udf for db2 (no specific platform).
> > now i am unsure if it would be better using c or java as programming
> > language. is there a benchmark for getting information about the
> > performance using these languages or a comparison?
>
> > thanks and regards
>
> C Not Fenced is the best (but you must make sure they are thread safe our
> you could bring down DB2.
> Java is the worst (always fenced).
> SQL is in-between.

From: Mark A on 9 Aug 2010 10:18
"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.


From: Helmut Tessarek on 9 Aug 2010 14:06
> thanks for answering. why is java the worst case in developing user
> defined functions? is there a benchmark or just own experience?

You can use db2batch to test the performance of your UDFs.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/
 |  Next  |  Last
Pages: 1 2
Prev: Business Intelligence extends Real Estate Reporting
Next: ASNCLP OFFLINE LOAD