On Fri, 30 Oct 2015 12:01:15 -0700 Roger Binns <rogerb at rogerbinns.com> wrote:
> https://sqlite.org/mmap.html > > SQLite supports memory mapping databases, but only does so for the > first 2GB of the file. My databases are around 4 to 20GB, and > completely fit within RAM on my 64 bit systems. The 2GB mmap limit > means that only a portion of the file benefits from the improved > performance, and much effort is wasted copying the data around bits of > memory. This limit is set at compile time with SQLITE_MAX_MMAP_SIZE compile option. I don't see at pager.c why it can't be bigger than 2GB, it's a 64bit integer. Try to compile with -DSQLITE_MAX_MMAP_SIZE=21474836480 and use a copy or backup, not the original database. > Roger --- --- Eduardo Morras <emorrasg at yahoo.es>
