T
tbergman
Guest
Progress 11.6, Windows I've been testing a couple of servers in a new network environment and was very displeased with some simple CS performance tests. Shared mem seems OK. I did two types of tests 1) A simple for each through a few tables. Some with many millions of records, some smaller. 2) A find next for 10k records in a loop for several different tables. With the default 1024 setting for -Mm, the for each tests were very slow. I did tests basically doubling -Mm each time until I got to the maximum allowable value of 32600. The find next tests were fairly consistent. No significant improvement. The for each tests were dramatically improved. Going from 1024 to 32600 resulted in huge improvement in performance with each increase resulting in more and more improvement. A typical result went from 13674ms to 899 ms. A larger table went from 856288ms to 33212ms. Shared memory for this larger table took 21718ms. The improvement is so dramatic that I'm looking to see if others have experienced similar results or if there's something unusual about our network or hardware. Has anyone had any adverse experiences with high values for -Mm? Thanks, Tom
Continue reading...
Continue reading...