No support for exec


I have a situation where I need to insert 70,000+ records into SQLite, but with the current implementation I have to execute each insert separately. The current implementation runs in about 8 minutes on my machine, but by running all inserts in a single exec command it runs in about ~40 seconds. Because of situations like this, it would be nice to include the exec command in the library.
Closed Nov 26, 2014 at 3:56 PM by marianosz


marianosz wrote Nov 26, 2014 at 3:56 PM

You can prepare one single statement with the massive insert and run it on one step. The API allows it.

SamuelMcAravey wrote Nov 26, 2014 at 5:21 PM

I realize that, but I cannot include update or delete commands, instead I would have to execute each of those individually. What I need is to be able to batch execute a bunch of different commands at once.