DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

Editor : Bulk insert

Editor : Bulk insert

magnus@greatlord.commagnus@greatlord.com Posts: 16Questions: 6Answers: 0
in General

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: 61,650Questions: 1Answers: 10,094 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: 16Questions: 6Answers: 0

    Hi Allan

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

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

    I am using the C# version I foget mentor that

This discussion has been closed.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2023 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.