P
Paul Koufalis
Guest
In my tests, I have found that you get the most bang for your buck up to 8192. Jumbo frames help, as Tom said. And the new prefetch params can also provide some dramatic improvements. At one customer we saw the following for a C/S request that read millions of records in two tables (10.2B08): default params: 12 min with -Mm 8192 and prefetch params: 2 min Sorry but I can't seem to find the raw data showing the difference between -Mm 8192 and -Mm 8192 + the prefetch stuff, but I do remember that it was significant. Another interesting C/S benchmark is the network distance: localhost vs. same VMWare server vs two physical servers. I don't have formal benchmark numbers but ad hoc testing seems to confirm that the difference can be massively significant. If you have your Apsv or TS clients connecting C/S to the DB, and everything is virtualized, it's significantly faster to be on the same physical host.
Continue reading...
Continue reading...