SQL Table Insert Very Slow
We are building a direct to SQL integration and are finding a number of the insert operations to be excruciatingly slow. The client is moving to Smart Connect from another tool that is being discontinued. The datasource is a SQL query and the destination is to a SQL table on the same machine. The integration is working, but the performance is not where it needs to be. In their prior tool performance was relatively fast.
Is there any tips or tricks to boost the speed of SQL integrations? Please advise.
JG