ddbc icon indicating copy to clipboard operation
ddbc copied to clipboard

Published 20 hours ago • verified publisher icon buggins

Is PreparedStatement.addBatch() available for efficiency purposes when performing insert/update?

Open rocex opened this issue 3 years ago • 2 comments

rocex avatar Dec 03 '21 08:12 rocex

it's not in the interface (I checked Statement and DataSetWriter as well):

https://github.com/buggins/ddbc/blob/d5a8a1ff9671b81dae098b75f37431669daf7ae4/source/ddbc/core.d#L353-L391

SingingBush avatar Dec 03 '21 08:12 SingingBush

it's not in the interface (I checked Statement and DataSetWriter as well):

https://github.com/buggins/ddbc/blob/d5a8a1ff9671b81dae098b75f37431669daf7ae4/source/ddbc/core.d#L353-L391

Yes, I checked this, too.

This is really a sad thing. When I use Java and SQLite, using addbatch is 10 times faster than not using addbatch, so I think if it is implemented on DDBC, it can be at least so fast.

rocex avatar Dec 03 '21 09:12 rocex