How to improve IoT application performance with multi-row DML.Whenever possible, use multi-row statements for DML queries instead of multiple single-row statements. DML best practices Use multi-row statements instead of multiple single-row statementsįor INSERT, UPSERT, and DELETE statements, a single multi-row statement is faster than multiple single-row statements. This page provides best practices for optimizing query performance in CockroachDB.