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] -----------------------------------------------------------------------------
