On Tue, Apr 04, 2006 at 04:18:35PM -0700, Sripathi Raj wrote: > On 4/4/06, Nathan Kurz <[EMAIL PROTECTED]> wrote: > > > > > >> 3. The performance for inserts is really bad. Around 40k entries > > takes a > > > >> few hours. What might I be doing wrong? I do a commit after > > > >> all the inserts. > > > > That doesn't seem right for speed. In addition to using "commit", are > > you beginning a transaction with "begin"? Are your inserts > > particularly complex or large? More details about what you are doing > > would probably be good here, since something odd is happening here. > > Maybe you could post a tiny test program along with the time it takes? > > I don't begin the transaction with begin. My assumption was that the first > insert operation would automatically begin a transaction.
True, it does an implicit "BEGIN", but it also does an implicit "COMMIT" when each command finishes. Try adding an explicit "BEGIN;" before you do the inserts: <http://www.sqlite.org/lang_transaction.html> --nate
