Add MaybeTransaction for better writing speed when supported #1740

Job	Run time
ci ubuntu-lts	2m 40s
ci gdal-static (ubuntu-latest)	21m 51s
Check spelling using Typos	6s
ci gdal-static (windows-latest)	24m 32s
ci gdal-3.10.0	2m 12s
ci gdal-static (macos-13)	1h 6m 53s
ci gdal-static (macos-14)	24m 41s
ci gdal-3.9.3	2m 22s
ci gdal-3.8.5	2m 26s
ci gdal-3.7.3	2m 31s
ci gdal-3.6.4	2m 24s
ci gdal-3.5.3	2m 24s
ci gdal-3.4.3	2m 24s
	2h 37m 26s

Provide feedback