J
James Palmer
Guest
Measured on logical vs record reads. The issue is that a colleague is running a similar query over an Appserver from a web interface and it's taking up to 20 times as long to run in live as soon as you add the address lookup compared to just having the customer. Buffer hits are pretty poor. Obviously the long term solution is to improve the buffer hit % for example. But to do that we need to do a lot of upgrading - not least 64bit OS and DB executables so we have a decent amount of RAM for the -B. I'm just trying to work out if there is anything we can do in the short term to improve the performance whilst we wait for the slow cogs of industry to turn and give us what we need to improve our hardware.
Continue reading...
Continue reading...