> Is there anybody using a non-power-of-2 database page size? > If I modify SQLite so that you cannot select a page size > that is not a power of two, will it break anybody's code?
I don't use a non-power-of-2 database page size, so I can't comment on the above. 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). However, if others have experienced the same as I have, it might be good to add something to the comment in pager.h about 4096 being a better page size on Win9X. HTH Ulrik Petersen -- Ulrik Petersen, Denmark Emdros -- the text database engine for analyzed or annotated text http://emdros.org/
