SQLite Insert very slow?

by

Wrap BEGIN \ END statements around your bulk inserts. Sqlite is optimized for transactions. 

dbcon = new SQLiteConnection(connectionString);
dbcon.Open();

SQLiteCommand sqlComm;
sqlComm = new SQLiteCommand("begin", dbcon);
sqlComm.ExecuteNonQuery(); 
//---INSIDE LOOP

 sqlComm = new SQLiteCommand(sqlQuery, dbcon);

 nRowUpdatedCount = sqlComm.ExecuteNonQuery(); 

//---END LOOP
sqlComm = new SQLiteCommand("end", dbcon);
sqlComm.ExecuteNonQuery(); 
dbcon.close();

More Related Contents:

  1. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  2. SQLite Database Locked exception
  3. Adding parameters in SQLite with C#
  4. Create SQLite Database and table
  5. Create/Use User-defined functions in System.Data.SQLite?
  6. SQLite keeps the database locked even after the connection is closed
  7. How does the SQLite Entity Framework 6 provider handle Guids?
  8. In sqlite I would do, But how in mongodb c#
  9. Unable to load DLL ‘SQLite.Interop.dll’
  10. Password Protect a SQLite DB. Is it possible?
  11. Is there a .NET/C# wrapper for SQLite? [closed]
  12. How do I get around the “‘” problem in sqlite and c#?
  13. auto create database in Entity Framework Core
  14. Problems using Entity Framework 6 and SQLite
  15. SQLite .NET performance, how to speed up things?
  16. What is the best way to connect and use a sqlite database from C#
  17. Getting the Last Insert ID with SQLite.NET in C#
  18. How to auto create database on first run?
  19. Enabling Foreign key constraints in SQLite
  20. Options for using System.Data.SQLite in a 32bit and 64bit C# world
  21. Unable to find the requested .Net Framework Data Provider – SQLite
  22. Visual Studio C# – SQLite.Interop.dll not found
  23. Problem using SQLite :memory: with NHibernate
  24. Encrypt SQLite database in C#
  25. How to create a password protected database?
  26. SHA1 hashing in SQLite: how?
  27. Why should I prefer single ‘await Task.WhenAll’ over multiple awaits?
  28. How to get client date and time in ASP.NET?
  29. More efficient way to get all indexes of a character in a string
  30. Encrypt Query String including keys

Leave a Comment