Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/bulk-insert below:

Bulk insert - Microsoft.Data.Sqlite | Microsoft Learn

SQLite doesn't have any special way to bulk insert data. To get optimal performance when inserting or updating data, ensure that you do the following:

• Use a transaction.
• Reuse the same parameterized command. Subsequent executions will reuse the compilation of the first one.

using (var transaction = connection.BeginTransaction())
{
    var command = connection.CreateCommand();
    command.CommandText =
    @"
        INSERT INTO data
        VALUES ($value)
    ";

    var parameter = command.CreateParameter();
    parameter.ParameterName = "$value";
    command.Parameters.Add(parameter);

    // Insert a lot of data
    var random = new Random();
    for (var i = 0; i < 150_000; i++)
    {
        parameter.Value = random.Next();
        command.ExecuteNonQuery();
    }

    transaction.Commit();
}

Collaborate with us on GitHub

Was this page helpful?

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4