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.

Long_to_varchar makes no performance difference?


 
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
jsales
Forum Member
Forum Member



Joined: 04 Oct 2005

Posts: 10
Location: Irving, TX



PostPosted: Tue Mar 07, 2006 2:49 pm 
Post subject: Long_to_varchar makes no performance difference?

The Peoplesoft source has may "comment" columns in it defined as LONG. I had rebuild the STAGE schema to change these LONGs to VARCHAR 1000 in order to use the LONG_TO_VARCHAR function when staging from the source. I thought this would improve execution time, since Oracle will force a commit after each row that contains a LONG in it. The DI warning goes away, but the execution time has not improved since I changed it. Can you suggest why this might be the case and what I need to do about it?
Back to top
dnewton
Forum Addict
Forum Addict



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


flag
PostPosted: Tue Mar 07, 2006 5:18 pm 
Post subject: Re: Long_to_varchar makes no performance difference?

In our experience the long-to-varchar function slows down the dataflow substantially. So it is probably eating up whatever performance gain you'd see by changing the rows per commit.
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.0262 seconds using 17 queries. (SQL 0.0019 Parse 0.0009 Other 0.0234)
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