Are the inserts inside a transaction? If you're doing a lot of identical inserts you can prepare your statement so it's parsed once and then just execute it repeatedly.
- Re: [sqlite] Slowness with in-memory database Jay Sprenkle
- Re: [sqlite] Slowness with in-memory databa... drh
- RE: [sqlite] Slowness with in-memory databa... CARTER-HITCHIN, David, FM
- Re: [sqlite] Slowness with in-memory da... Jay Sprenkle