Revision history [back]

The most effective way to update many rows in GridDB is to use the Batch operation feature. With the Batch operation, you can execute multiple operations such as Insert, Update, Delete, etc. in one transaction, which reduces the overhead of committing each operation one by one. This results in faster updates and better performance. Additionally, you can also use Prepared Statement to reduce the overhead of preparing SQL each time you execute a query.