SQLite Forum

Memory-mapped IO used for temp files even though memory-mapped I/O is not used
Current thinking is that memory mapping isn't all that much of an advantage when sorting data. Not on modern Linux (and presumably other modern OS versions as well) anyway. So it will be turned off by default for 3.37.0: