On Wed, Sep 15, 2004 at 02:14:58PM -0700, Roger Dant wrote: > > Here's the slow code: > > sqlite3* db; > CString sql; > sqlite3_open("c:\\test.db", &db); > sqlite3_exec(db, "PRAGMA SYNCHRONOUS", NULL, NULL, NULL); > sqlite3_exec(db, "CREATE TABLE X (I LONG, J LONG)", NULL, NULL, NULL); > for (int i = 0; i < 1000; i++) { > for (int j = 0; j < 500; j++) { > sql.Format("INSERT INTO X VALUES (%d,%d)", i, j); > sqlite3_exec(db, sql, NULL, NULL, NULL); > } > } > sqlite3_close(db);
Adding a BEGIN at the start and COMMIT at the end makes this test complete in 14.5 seconds for me. Cheers, Matt