How can one improve performance while writing back into database? I am using standard tools and that's why I cant use in-db tools? Is there any way out to improve performance while writing back into my database?
Streaming in and then doing the write in db is also not effective! Any tips?
解決済! 解決策の投稿を見る。
Hi @rajatjain1
What Database are you writing to? If there is a bulk loader for it, that will drastically improve the performance of writing to the database compared to using OleDB or ODBC drivers.
SQL Server...I don't see any option of bulk load!
Hi Joe,
I was able to find the bulk loader and it has reduced the time taken to insert. Although i am facing one issue while changing out output tool from ODBC To Bulk Loader.
It threw an error:-
Could not find stored procedure 'sp_describe_first_result_set'
I never created any procedure in the first place but somehow it is requesting for a stored procedure. Can you help in this?
What version of SQL are you using?