Re: [sqlite] Performance...there must be a reason

[D. Richard Hipp]

Avner Levy wrote:
I've downloaded the latest src and compiled the new version 2.8.11 on 
Solaris 2.8 and tried to check the lock fix with the threadtest1.c.
The output was as followed:
======================================================================================= 

2.testdb-4: command failed: INSERT INTO t2 VALUES(58,116,3364); - 
database schem
a has changed
======================================================================================= 

If you change the "if" on line 147 to a "while", I think
it will clear this problem.
*** threadtest1.c       14 Jan 2004 03:32:38 -0000      1.1
--- threadtest1.c       21 Jan 2004 13:34:04 -0000
***************
*** 144,150 ****
    va_end(ap);
    if( verbose ) printf("EXEC %s: %s\n", zFile, zSql);
    rc = sqlite_exec(db, zSql, 0, 0, &zErrMsg);
!   if( rc==SQLITE_SCHEMA ){
      if( zErrMsg ) free(zErrMsg);
      rc = sqlite_exec(db, zSql, 0, 0, &zErrMsg);
    }
--- 144,150 ----
    va_end(ap);
    if( verbose ) printf("EXEC %s: %s\n", zFile, zSql);
    rc = sqlite_exec(db, zSql, 0, 0, &zErrMsg);
!   while( rc==SQLITE_SCHEMA ){
      if( zErrMsg ) free(zErrMsg);
      rc = sqlite_exec(db, zSql, 0, 0, &zErrMsg);
    }




--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]