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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

XM file genration


 
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
kannar
Senior Member
Senior Member



Joined: 01 Aug 2011

Posts: 36



PostPosted: Mon Apr 18, 2016 3:57 pm 
Post subject: XM file genration

Hi All,

I build a job to generate XML file and when i ran for just two employees it completed with in mins. But now i have to run this for around 60,000 employees and it's running from last three hours. Attached is my Data flow.

is there any suggestion to reduce running time .
Back to top
barthodo
Principal Member
Principal Member



Joined: 18 Apr 2012

Posts: 231
Location: Munich


flag
PostPosted: Tue Nov 14, 2017 3:00 am 
Post subject: Re: XM file genration

Do you see any CacheMemoryReader in Monitor Log during execution?
It could be, that optimizer first caches all data and building a cartesian product of all combinations and then building the result.

In that case please check table caching settings, join ranks.
Maybe use multiple quieries to logicially join the data (incl. caching and join ranks)-.
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 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0337 seconds using 17 queries. (SQL 0.0070 Parse 0.0009 Other 0.0259)
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