On 16 Jan 2015, at 12:39pm, Jan Slodicka <j...@resco.net> wrote: > Thanks to your post I discovered multiple-row inserts so that I now > understand what you asked.
Just a note that multiple-row inserts were added to SQLite relatively recently (2012-03-20 (3.7.11)) and, because SQLite does only database-level locking, its overhead for INSERTs is far less than that of SQL Server. It might be faster to use them but I would expect it to be so much faster than many inserts as part of one transaction. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users