Improving performance while writing into database

[rajatjain1]

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?

[JoeS · Accepted solution]

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.

[rajatjain1]

SQL Server...I don't see any option of bulk load!

[JoeS]

Hi @rajatjain1 

What version of Alteryx are you using?

[rajatjain1]

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?

[JoeS]

What version of SQL are you using?