Hop, voilà le lien où j'ai trouvé ce que je raconte :
No multiple network round-trips. Once the bulk-insert operation is setup, we send rows from the client to the server continously, without going back-and-forth over the wire.
Server storage engine also can greatly optimize how rows are inserted when performing a bulk-copy operation. How much can be optimized depends a lot on the recovery model the tarder database is set to; in "simple" and "bulk logged" the overhead of logging is greatly reduced during bulk-copy operations, helping a lot with performance.
[/I]
(source :
http://davidhayden.com/blog/dave/arc...3/08/2877.aspx)
Je pense vraiment qu'il ne s'agit pas de simples requêtes sql en background.
Partager