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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: BOBJ conference in Paris: Mar 28, PGHBOUG: Apr 4.

Data loading to Postgre is too slow in DS 4.2


 
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
DbUoRdAsI
Principal Member
Principal Member



Joined: 08 May 2012

Posts: 119


flag
PostPosted: Sun Mar 18, 2018 1:18 pm 
Post subject: Data loading to Postgre is too slow in DS 4.2

Hi All,

I am trying to load data to Postgres DB. Performance is to too slow, it takes 8 hrs to load 1 Million records for simple source to target mapping.
Postges version: 9.6.6.

I tried to load same data set to MS sql server, it takes only few mins.

I optimized the job, still performance is too low.

Can anyone please suggest how to improve the data loading performance for ODBC based target database.

Thanks
Back to top
nithya_raj
Forum Associate
Forum Associate



Joined: 03 Feb 2007

Posts: 978



PostPosted: Sun Mar 10, 2019 3:34 am 
Post subject: Re: Data loading to Postgre is too slow in DS 4.2

Hello,

Did you manage to find a solution for this?

Thanks,
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.0293 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0257)
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