BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

Load data with and without sysdate() returns very less perf.


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
jar80
Principal Member
Principal Member



Joined: 06 Oct 2005

Posts: 233
Location: Chicago



PostPosted: Thu Mar 09, 2006 11:57 am 
Post subject: Load data with and without sysdate() returns very less perf.

Hi
i have table from source which takes 90 min to load each time i do, but now i have added four date columns to the target and assigned default value sysdate() to all of them, now the load is going on for 7 hours and till only 50% of data is loaded..

Does DI calculates sysdate() for each row and sends to DB or directly sends sysdate() where Oracle executes it?

Using sysdate() really affects the performace or there may be any other issue?

Thanks in Adv
Raj
Back to top
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3446
Location: Massachusetts, USA


flag
PostPosted: Thu Mar 09, 2006 12:22 pm 
Post subject: Re: Load data with and without sysdate() returns very less p

We have also experienced strangeness when using sysdate() and you have two source tables in an outer join -- sometimes sysdate() returns no value at all! (Logged as a bug already with tech support.)

I recommend you set sysdate() in a script step before the dataflow, into a variable, and use that variable in your dataflow.
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10593
Location: Germany


flag
PostPosted: Thu Mar 09, 2006 1:01 pm 
Post subject: Re: Load data with and without sysdate() returns very less p

The sysdate() function returns a date whenever it is called. So over a run of x hours you will get different values. Variable is much more convienent.

We pushdown sysdate() in into select statements, but not into INSERTs.

_________________
Werner Daehn
ex Product Manager Data Services at SAP SE

www.rtdi.io
Back to top
jar80
Principal Member
Principal Member



Joined: 06 Oct 2005

Posts: 233
Location: Chicago



PostPosted: Fri Mar 10, 2006 4:38 pm 
Post subject: Re: Load data with and without sysdate() returns very less p

A wired behaviour ...Dont know whts happening??

A one - to -one mapping from source is taking hours even i remove the sysdate() also..?

how can i check how many threads and why its actually taking more time?

thanks in advance
raj
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0276 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0239)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo