> -----Original Message----- > From: Stephen Sutherland [mailto:[EMAIL PROTECTED] > Sent: Friday, August 03, 2007 10:33 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] How to Speed of Inserts > [snip] > > So it makes me a bit concerned that when I have to drop my > XML repository with 7,000 to 10,000 records it will take > forever at application start up ? > > Is there a way to execute all these inserts much faster > than I am currently doing ? > > I am currently simply using sqlite3_exec(db, "INSERT SQL > STATEMENT ", ... etc etc ) > for every single insert statement. > > Is there away to maximize this speed dramatically to do > 10,000 inserts in less than 5 seconds. >
3 words .... Transaction Transaction Transaction. Issue a BEGIN before you start inserting, and a COMMIT afterwards, and then come back and tell us how many MILLISECONDS it took. Robert ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------