System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
Ticket Hash: 2cd99601e66566c39a722bc8b3b884832baa99b3
Title: BulkCopy support
Status: Open Type: Feature_Request
Severity: Minor Priority: Low
Subsystem: None Resolution: Open
Last Modified: 2018-01-24 08:27:31
Version Found In: 1.0.66.0
Description:
BulkCopy support would be great in the near future

regards,
Simon
User Comments:
anonymous added on 2018-01-24 08:27:31: (text/x-fossil-plain)
I created a "BulkCopy" class based on a insert statement with parameters and multiple value sets.

INSERT into <table> (Column1, Column2) values (?,?),(?,?)

The interface has an array of types for the columns and a IEnumerable<object[]>.

The advantage over a normal insert statement. It removes a lot of overhead and checks. The inner loop only binds the parameters, execute, reset and clear the statement. That's super fast. With this solution I was able to insert (int, string of 1 char) over 3 million rows per second on my machine.