Performance tips when working with databases

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.

Create indexes

If you are running custom SQL queries or using MERGE/UPDATE/DELETE/IfExist SQL actions - make sure that all relevant database indexes exist.