Thanks a lot to you both! - Jon
-----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 8:57 AM To: SQLite Subject: [sqlite] Re: best performance Jonathan Kahn <[EMAIL PROTECTED]> wrote: > In my application I currently perform a loop inside a recursive > function and sqlite3_bind_* on various fields then call sqlite3_step > and a reset inside my loop but it is fairly slow when inserting, is > there a faster way of inserting inside a loop? Make all your inserts within a single transaction (issue BEGIN statement before the loop and COMMIT after). Igor Tandetnik ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
