Dyonight
I think I don't understand cache that much...
I think windows cache is the pagefile
There are many types of caches, even in the same OS. One important one in the case of Sonar would the be the disk cache. MD (magnetic, or non-SSD disks) are actually very slow. If there was no disk cache, things would run painfully slow. A cache can hide the slow disk issues from the user by temporarily "writing" to RAM, and then stream the data to the disk in the background afterwards. Or in the case of reading, start reading the next blocks of data ahead of time into RAM in case that is what the program was planning to do next, which is very often the case.
MD access times are especially bad, something like 10ms. SSD access times are super fast in comparison, something like 0.02ms. That makes a huge difference when reading lots of small blocks of data at random locations (say, a sampler loading lots of different samples into memory).
A pagefile is a different kind of cache. Applications use virtual memory, which means the OS can give an application all the memory it asked for, even if you don't have that much RAM available. So if a new application asks for memory but the RAM is filled, the OS will save the memory from another application (or even the same application) that hasn't used it recently to disk (into the pagefile). Then later when that other application tries to do something with the memory that is now saved to pagefile, the OS will first save yet another application's memory to the pagefile, and then load the requested memory into the freed RAM and let the application continue. It's a sort of musical chairs with memory.
So that is why putting a pagefile into a RAM disk defeats the purpose, because now you have less RAM available for applications, requiring the pagefile to be used sooner.