When we run an update against a table of 40k rows on a NT environment, it completes in 10 sec.
When the same update is executed on a Linux environment with the same # of records, it completes in 19 sec - nearly 100% drop in performance.
The explain plans are the same for both environments (NT and Linux)
I know it’s a very generic question but would appreciate if you could provide some pointers to why there is this difference and how I can diagnose and fix this. Thank you.
May 23, 2008 3:21 PM
May 23, 2008 4:59 PM