You are right, we could probably re-run SQLite purely in memory, but only because macos dynamically allocates additional swap. However, I would not expect much

You are right, we could probably re-run SQLite purely in memory, but only because macos dynamically allocates additional swap. However, I would not expect much improved performance, because I do not believe that SQLite has a different sorting strategy when running in memory. It would only save some i/o operations, which are very cheap on the macbook anyway. Either way, would be an interesting experiment.