On Wed, Sep 22, 2010 at 10:19:27PM +0400, Max Vlasov scratched on the wall: > 1024 for everything except Windows. The Windows filesystem module > > attempts to match the page size to the minimum write block of the > > filesystem. For a typical NTFS volume, that's usually 4K. > >
> Jay, small correction, the default page_size on windows is still 1024 > (checked it), there's just an advice on the site wiki to change it to the > cluster size immediately after the db creation ( > http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows). It is a bit more complex than that. A new database does not always use exactly SQLITE_DEFAULT_PAGE_SIZE. From <http://sqlite.org/pragma.html#pragma_page_size>: "...the default page size is the larger of SQLITE_DEFALT_PAGE_SIZE and the sector size as reported by the xSectorSize method of the sqlite3_io_methods object, but not more than SQLITE_MAX_DEFAULT_PAGE_SIZE. The normal configuration for SQLite running on workstations is for atomic write to be disabled, for the maximum page size to be set to 65536, for SQLITE_DEFAULT_PAGE_SIZE to be 1024, and for the maximum default page size to be set to 8192. The default xSectorSize method on workstation implementations always reports a sector size of 512 bytes. Hence, the default page size chosen by SQLite is usually 1024 bytes." -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
