BusinessObjects Board

Regarding performance of custom functions.

dataservices performance
#1

Hi Team,

I have a dataflow which is having 12 custom functions each custom function will run 3 times for an attribute with different input parameters , i have 15 attributes which call these custom functions, function has sql statements inside it. All functions have "enable parallel execution " enabled.The performance of the Job is for 3000 records it is taking 3.5 hours.Then i applied DOP =5 and loader =5 it gave good improvement and it is now taking 1.5 hours but still management is not happy about the throughput and i explained them everything no luck.Is there any way , i can improve the performance further,

Server details :
OS:Windows
RAM-32GB
CPU-8

jmuthukumaran :us: (BOB member since 2011-09-13)

#2

Use DB functions instead of DS functions when you are calling SQL. You can import the database functions via the data store. That should help greatly.

Alternatively, get rid of the SQL() functions altogether and use a combination dataflows and lookup_ext with custom SQL as a replacement.

  • E

eepjr24 :us: (BOB member since 2005-09-16)