Posted: Fri Jul 22, 2016 1:03 pm Post subject: Faster database insert ti oracle database
Master
Joined: 05 Dec 2007 Posts: 296
Hi I need help. I have a flow thats reading multiple messages into the queue. All these messages need to be writing to database. Flow is currently designed as
Mq in >> compute.
In the compute I am building the insert statement then run PASSTHRU to insert to 2 tables. Is there anything I can do to improve performance since I received 105000 transactions in 30 minutes. . How can I do bulk insert.. or should I build my insert statement and store into a file. . Then do bulk insert? Please help.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum