ACCOUNTING CPU usage fpr UDF

Database

ACCOUNTING CPU usage fpr UDF

We want to create UDF to perform some text manilulation like Oracle UDF's.

To  Evaluatet he effectiveness of these function we are planing to compare CPU utilization for the query using these UDF's and find equavalent SQL code perform the same functionality.

Our Question is: Do CPU accouting for the session recorded in DBQL table will include the CPU seconds spent runnint the C code called by these delpoled UDF's.

we are worried that the comparision will be cumbersome of the DBQL CPU Accounting will not include the CPU seconds spent on the any UDF's

Tags (1)
2 REPLIES
N/A

Re: ACCOUNTING CPU usage fpr UDF

Which TD version do you run?

And which UDF language do you use?

To my knowledge does 13.10 account for C UDFs but I am not sure about JAVA. At least in the past Java UDF CPU usage was not captured in DBQL

Re: ACCOUNTING CPU usage fpr UDF

it's C and we are 13.10.

So it will be accounted though !