Editor : Bulk insert

magnus@greatlord.com

Hi
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 ??

allan

Hi,

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.

Allan

magnus@greatlord.com

Hi Allan

Thanks for the answers, it was that I wanted to known.

magnus@greatlord.com

I am using the C# version I foget mentor that