SQL table updation

[Nandakishore]

Hello,

How to bring down the time taken to update and insert records within SQL using Alteryx solution . 

Thankyou . 

[ed_hayter]

Without knowing the details you could use a formula tool  with the following function:

datetimetoday()

To assign a timestamp to records before writing records to the database.

If you are using the IN-DB Formula tool a function like GETDATE() should get you the timestamp for the current DB you are connected to.

[Nandakishore]

Hi @ed_hayter  ,

Thanks for reply .

Iam actually looking a way how to load the records faster into the db . Is there any smart way to do it .

Thanks

[ed_hayter]

When writing to database are you using a Bulk Loader connection? If that is an available option to you it can improve write speeds.

also a range of ideas at this link 

https://knowledge.alteryx.com/index/s/article/How-to-troubleshoot-slow-DB-speed