Question about ADAPT01731386

[Former Member]

Hi all together,

we have a problem with a data services 4.2 environment. When we enable the execution option "Collect statistics for optimization" the execution of a data services job takes much more time than running the job without the option set. Without the option the job needs around 3 minutes and with the option set > 6 hours.

At the moment we are using BODS 4.2 SP2 PL1 and think about an upgrade to BODS 4.2 SP 3.

There is included ADAPT01731386. The description says "When using the run_batch_job web service, the "Collect statistics for optimization" option is not exposed. This issue has been fixed in this release."

Did anyone experienced the same problem as we do and could tell us if the installation of BODS 4.2 SP 3 could fix the problem?

Best regards

Stefan

[Emiliano]

The run_batch_job web service is a web service you can call to start your jobs, the issue is about an option in the web service that was missing. So if you are not using this web service it will not affect your job.

I think your issue is caused by the dataflows that are using pageable cache, slow but usually bigger, instead of server physical memory which is much faster.

The job engine will use the statistics to determine if dataflows can use the physical memory and running faster but when collecting statistics it will use pageable cache for every dataflow to be sure it will not fill up all the physical.