If you must insert many rows, use INSERT INTO ... VALUES with multiple tuples in one statement, or commit every 500 rows. The driver’s transaction support is limited; large single transactions can lock the NSF.
Lotus Notes Migration: 4 Reasons to Migrate Apps to the Cloud - Mendix lotus notessql 206 driver top