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: No events within the next 45 days.

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



Joined: 24 May 2019

Posts: 1



PostPosted: Fri May 24, 2019 2:03 am 
Post subject: Re: Data loading to Postgre is too slow in DS 4.2

Norton.com/Setup is most popular antivirus setup from Norton which protects you online & offline from virus and malware. Download your setup here Norton.com/Setup

Office.com/Setup is a software which is used by almost all company and business and even by individuals For all their office activities or for personal use. It has excel, word, and ppt as their constituent are most widely used apps.

Office.com/Setup is a set of desktop applications, which is widely used products for the home as well as an office. Microsoft office gives the freedom of writing documents, blogs, letters and with the use of Microsoft office PowerPoint one can prepare a presentation also.

mcafee.com/activate is a antivirus software for laptop, PC, Mac for internet security form viruses and malware. Enter code to get started and protect while online surfing and downloading.

mcafee.com/activate Since the world is developing each day with new computerized advances, digital dangers, malware, information, and harming diseases have additionally turned out to be increasingly more progressed with every day.
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.0267 seconds using 17 queries. (SQL 0.0023 Parse 0.0008 Other 0.0236)
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