topic Re: DBSLICE degraded performance a bit in SAS DI Studio 4.2?? in SAS Enterprise Guide

DBSLICE degraded performance a bit in SAS DI Studio 4.2??

deleted_user — Mon, 27 Apr 2009 14:13:57 GMT

Hi Linus( 😉 ) and others,

I have a job which extracts 10 million from an ORA table and loads it into a SAS dataset. When I ran teh job without DBSLICE this took 15 min.

Next I ran the same job with DBSLICE option(my condition was fetch 1- 500000 in one thread and 500001 - 10 million in second thread). This time teh job took 19 minutes.

I tried using DBSLICE in base SAS. There it is working just fine. I can see good improvement in performance as and when I increase the number of threads.

Not sure if in DI studio, why this is behaving this way.

Re: DBSLICE degraded performance a bit in SAS DI Studio 4.2??

deleted_user — Mon, 27 Apr 2009 14:23:30 GMT

I ran the same job with 3 threads and the job ran for 21 min.

Im using Table Options in "ORA source table" in DI studio to set DBSLICE param. The condition I'm using is

DBSLICE=("COL_1<3000000" "COL_1>=3000000 and COL_1<6000000" "COL_1>=6000000")

Re: DBSLICE degraded performance a bit in SAS DI Studio 4.2??

LinusH — Mon, 27 Apr 2009 14:24:46 GMT

Tough one.
First, when running jobs from DI Studio, it is a matter of executing SAS programs through a workspace or a batch server. Having said that, when you say ".. DBSLICE in Base SAS.", do you mean through a DMS SAS session, or a source editor window in DI Studio, or...?

So, you have to figure out what's different between how you run your code. This involves comparing programs, logs, options settings (system, Libname and optional table/data set). I'm afraid that doing this type of analysis the Forum is not the best suited arena. If you need further help, SAS support might be your best friend.

/Linus

Re: DBSLICE degraded performance a bit in SAS DI Studio 4.2??

deleted_user — Tue, 28 Apr 2009 11:29:18 GMT

Raised a ticket with Tech support. Lets see what they say.