On Thu, Oct 23, 2008 at 11:23:36AM -0500, Nicolas Williams wrote: > 6755391 sqlite3 should not be built with SQLITE_DEBUG; uses access(2) too > often, slows things down > 6762083 sqlite3 default pagesize selection could be better (SQLite3 ticket > #3452) > > http://cr.opensolaris.org/~nico/sqlite3-big-pages/
Well, it turns out some SQLite3 tests fail. I'm going through all the failures and most have to do with the number of pages that a DB is expected to take up after operations like VACCUUM and autovaccuum. But there is one failure that results in a malformed DB when using autovaccuum on a DB with pagesize > 16KB. So methinks the best we'll do is end up with 16KB page sizes. Also, I may want to figure out what the patches to the tests should be so they take page size into account. That will take time. So I'll probably spin up a new ws with just the fix for 6755391. Nico --
