You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Enterprise Data Integration » General questions
- » Improve Performances of tMSSqlOutputBulkExec
#1 2010-04-22 16:01:54
- mnoviant
- New member
- Registered: 2010-04-22
- Posts: 8
Improve Performances of tMSSqlOutputBulkExec
Hello,
I have a very big table to extract and load fastly so I use the bulk component.
My database is MS SQL SERVER 2005
My table has 5000000 lines and 220 columns.
The performances are not very good: only 4000 lines/sec
I do this with other tables with Multithread option.
How can I improve the performances of my jobs?
Best regards
Michel
Offline
#2 2010-12-18 12:33:35
- Ruhul
- Guest
Re: Improve Performances of tMSSqlOutputBulkExec
I am also in same situation with oracle. If I faced Data direct oracle to oracle , 500000 record took 25 second. But if I used TALEND to transfer it took long time and I was never success.
Regards
Ruhul
Pages: 1
- Index
- » Talend Enterprise Data Integration » General questions
- » Improve Performances of tMSSqlOutputBulkExec