Author |
Message |
Smarty Forum Member


Joined: 12 May 2008
           Posts: 23

|
Posted: Tue Jul 07, 2015 9:12 pm Post subject: BODS 3.2 SQL transform with bulk load API takes forever |
|
|
I have a data flow that has sql transform with bulk load API, however this DF takes forever to load 300k records. The monitor log says status READY after 10 hours it loads data fine. I have checked Data service performance monitor and data base sql/session monitor there is nothing unusual.
Please let me know what might be causing this issue?
/thanks
Smarty |
|
Back to top |
|
 |
eganjp Forum Addict


Joined: 12 Sep 2007
             Posts: 4280 Location: Denver Area

|
|
Back to top |
|
 |
amuh10 Principal Member


Joined: 11 Apr 2012
        Posts: 108

|
Posted: Fri Jul 24, 2015 9:32 am Post subject: Re: BODS 3.2 SQL transform with bulk load API takes forever |
|
|
If the Monitor log says READY, that means the SQL is seems push down to the SQL level. So my understanding is that you have a issue with your joins, as 300k records should not 10 hours to load. |
|
Back to top |
|
 |
|