> How big is the database file in the filesystem after you do this? > Can you post it (the database file)? Have you defined any preprocessor > macros when compiling, for example SQLITE_DEFAULT_AUTOVACUUM or one > of the OMIT symbols?
Hi Dan, how you can see in my other mail, starting with a new (and so empty) database sqlite> create table tbl1(one varchar(10), two smallint); sqlite> PRAGMA integrity_check; *** in database main *** Page 2 is never used sqlite> .dump BEGIN TRANSACTION; CREATE TABLE tbl1(one varchar(10), two smallint); COMMIT; I have defined this macro: # define TEMP_STORE 3 and -DTHREADSAFE=0 -DSQLITE_OMIT_AUTHORIZATION=1 but somtimes I try other macro combination like these: -DSQLITE_NO_SYNC -DSQLITE_DISABLE_DIRSYNC -DSQLITE_OMIT_FLOATING_POINT -DSQLITE_DISABLE_LFS -DSQLITE_OMIT_CURSOR with the same result thank you for your attention to my problem, Andrea Federico -- ___________________________________________________ Play 100s of games for FREE! http://games.mail.com/
