Increase amount of read operations
First the question then the background:
Can you increase the amount of read operations that are being performed simulatiously to the hard drive where the cache.dat file is located.
Alternatively: Can you increase the amount that is being read with every operation?
The database is setup with 8k blocks of data that are being read. I'm currently struggeling with a bottleneck concerning the read operations from a disk.
I'm assuming this based on the fact that the same routines when run twice in row perform vastly different. With the first being extremely slow up to multiple seconds and the second one being around half a second or less. Aswell as every subsequent one from there on.
As far as I understand, Caché uses memory to store recently accessed data, therefore this would explain why the second run of the same routine outperforms the first one so much since it's run from RAM
Looking at the windows ressource monitor it is visible that the cache.exe process responsible for reading the most data, at most uses around 20 MB/s of a possible 160 MB/s the disk provides. When performing tasks like moving a big file from A to B with the windows explorer, the ressource monitor shows that the peaks of 160 MB/s can be achived, so it's not a matter of other processes taking the rest of the performance.
Maybe there is a setting in the Management Portal to increase the read performance?