Use streaming and bind variables if possible, but avoid using native SQL
Enable Force streaming when streaming is not supported
Read about force streaming.
Enable Auto Commit
If you are loading large datasets into the database, enable Auto Commit for the destination database connection.
If you are running custom SQL queries or using MERGE/UPDATE/DELETE/IfExist SQL actions - make sure that all relevant database indexes exist.