Editor : Bulk insert

Editor : Bulk insert

magnus@greatlord.commagnus@greatlord.com Posts: 15Questions: 6Answers: 0

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

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 52,525Questions: 1Answers: 8,020 Site admin
    Answer ✓

    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.commagnus@greatlord.com Posts: 15Questions: 6Answers: 0

    Hi Allan

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

  • magnus@greatlord.commagnus@greatlord.com Posts: 15Questions: 6Answers: 0

    I am using the C# version I foget mentor that

Sign In or Register to comment.