J
James Palmer
Guest
As stated before, the 2 biggest limiting factors you have are your Progress version, and the Workgroup license. -B is the cache. It won't make a bit of difference for things other than the disk reads as cached records are read from memory rather than disk. You definitely should set it as high as you can. If the server isn't overloaded with 3,500,000 then leave it at that - the users will be appreciative in the long run. In your position, if there is money to spend then you need to look at removing the next obvious limiting factors as just mentioned. I completely understand Progress version being out of your hands. Been there before, but upgrading to Enterprise would definitely be possible as it makes no difference to the application. This will enable you to tune a number of switches under the bonnet.
Continue reading...
Continue reading...