Ulrik Petersen said: > However, slightly off-topic, but still about page sizes: I have found > empirically that a page size of 4096 gives better performance on Windows > (particularly Windows 9X). > > The SQLite source (pager.h if I am not mistaken) says that a page size of > 1024 seems to be best. This is correct in so far as Linux doesn't see any > performance increase with larger page sizes (I've verified this > empirically, too, for 4096 and 16384).
Is there a chance that it's related to block size on the disk? Traditionally with ISAM systems matching page size to block size was the key to good performance. I seem to recall that NTFS defaults to 4096 byte blocks. Clay Dowling Rampant Speculator -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development