This content has been marked as final. Show 2 replies
It's hard to make definitive statements without more details but in general comparing 184.108.40.206.1 (latest GA release) to 7.0.x.y.z1 person found this helpful
1. Query performance will be better. For complex queries it may be much better as there have been many optimizer and execution engine improvements.
2. Single threaded DML performance will be ower due to the increased code path of the parallel log manager.
3. Multi-threaded / multi-process DML throughput will be higher and SMP scalability will be much higher due to numerous internal optimizations and the parallel log manager.
But of course you need to test the two releases with your workload on your hardware to see for certain.
I agree with Chris. The performance should be better, but before migrate please make some test and check it.