SQLiteで主キーにAUTOINCREMENTを指定すると遅くなる - Qiita

CREATE TABLE AutoincrementTable ( Id INTEGER PRIMARY KEY AUTOINCREMENT, Value INTEGER NOT NULL ); using System; using System.Data; using System.Data.SQLite; using System.Diagnostics; using System.Linq; using Dapper; namespace ConsoleApplication2 { internal class Program { private const int InsertCount = 1000000; private const string FileName = "Test.db3"; private static void Main(string[] args) {