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
