Does the editor generate one sql statement for bulk insert or does it doing one insert at time for bulk insert to the database table ??
This question has an accepted answers - jump to answer
It does it one at a time (in a single transaction, if transactions are enabled, which they are by default).
So to answer where you are going with this, if you are inserting a large number of rows, then absolutely it could be optimised by using a single SQL INSERT statement. Our libraries don't currently do that though I'm afraid.
Thanks for the answers, it was that I wanted to known.
I am using the C# version I foget mentor that
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.