You can improve bulk processing performance for database batch insert, update, and delete operations by using the database/batchUpdates setting in the prconfig.xml file or dynamic system settings. This setting lets you override the default batch size during a Commit operation for databases that support batch updates.

• Database tables
• Default database tables
• Commit method
• Database table primary key (handle)

• Running SQL queries on Pega Cloud