in reply to Much slower execution from one machine to another

Could you post the output from -V on both setups; they might shed some clues.

Another possibility is do both setups use the same connection mechanism (unix/network port; pipe; odbc etc.) to the DB?

One change to do with IO I'm aware of between those two versions is the size of the internal buffers used which I believe went from 4K to 8K. For disk that's generally a good thing (16K would be better still!), but if the change also affects the relevant transport IO; it could be detrimental.


With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority". I knew I was on the right track :)
In the absence of evidence, opinion is indistinguishable from prejudice. Not understood.
  • Comment on Re: Much slower execution from one machine to another