On Mon, 25 Aug 2008 12:26:18 -0700, you wrote: >Interesting, I just tried that in my test application and Dennis's and I >get access violations during the vacuum command execution when trying to >resize the pages from 1k to 4k with my database or Dennis's test >database.
I just used the command line tool, exactly as shown. Platform: MS Windows Vista Ultimate SP1. My previous test was on a small database and SQLite 3.6.0. The run below is with SQLite 3.6.1 and a bigger database: \research>copy \data\opt\fos\repo\fossil tmp \research>dir tmp\fossil 2008-08-25 15:37 4.583.424 fossil \research>%sqlite% "tmp/fossil" SQLite version 3.6.1 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> PRAGMA page_size; 1024 sqlite> select count(*) from blob; 3374 sqlite> PRAGMA page_size=8192; sqlite> VACUUM; sqlite> PRAGMA page_size; 8192 sqlite> select count(*) from blob; 3374 sqlite> .q \research>%sqlite% "tmp/fossil" SQLite version 3.6.1 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> PRAGMA page_size; 8192 sqlite> select count(*) from blob; 3374 sqlite> .q \research>dir tmp\fossil 2008-08-25 23:43 4.775.936 fossil So, it works. Perhaps there is an esential difference between your test program and the command line tool? -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
