|Powered by QM on a Rpi server|
Windows systems allocate memory in a manner that can prevent QM making best use of unused space to cache disk blocks. The effect on application performance can be massive. For example, a test program that writes 500,000 records, each about 250 bytes in size, with sequentially numbered record ids took over 20 minutes on a 1Gb system with the default Windows XP performance settings but only 23 seconds with the change described below.
Beware that changing Windows memory performance options to benefit QM may have a detrimental effect on the performance of other software. The best approach is to try it and decide which setting works best in your particular situation.
To find the relevant performance option:
Nothing is easy!
Choosing a group size that matches the underlying operating system page size may also be beneficial. In Windows systems, this is 4kb.