I was investigating if file mapping could be used under win32, but have run into a roadblock. The win32 documentation for MapViewOfFile (which is the part that maps the drive data into memory) wants the file offset to be a multiple of the allocation granularity of the system. On my machine (XP Pro) it happens to be 65536. This value happens to be the upper range that the pager can handle, however, change the SQLITE_MAX_PAGE_SIZE and SQLITE_DEFAULT_PAGE_SIZE to this value causes the system to crash. The highesrt value that works is 65528, 8 less than the max. The reason I can't use anything higher is because of the macro FORCE_ALIGNMENT during opening the pager. So, is what I'm attempting pointless, should I work around the problem when I try to map the ranges and map more in than needed, or something else?
-- Joel Lucsy "The dinosaurs became extinct because they didn't have a space program." -- Larry Niven