469,568 Members | 1,382 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

Java UDF performance trouble

4
I need UDF which would parse one clob column MESSAGE + extract some data to fill some other columns in the same table.
I will use 'generate as' feature for corresponding columns, where UDF to be called.

For instance, the simplest case is the column, that just needs first 8 letters of MESSAGE.
To test java UDF, i've used analog of LEFT(MESSAGE, 8) - which works fine - MESSAGE.getSubString(1, 8) and this java class also works, but VER-R-R-RY SLOWLY!
Handling 4800 records took about 5minutes!!! It's intolerable.

How may I increase its performance??

P.S. DB2 version is 9.1.0.356
Dec 7 '06 #1
0 951

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

54 posts views Thread by Spammay Blockay | last post: by
5 posts views Thread by Zach | last post: by
10 posts views Thread by Alex Gerdemann | last post: by
30 posts views Thread by Mike Cox | last post: by
9 posts views Thread by babylon | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.