03.01.2015 03:08, André Knappstein wrote:

>
> I created a test table on both old and new server to play with updates
> and inserts (~ 150.000 records)
> Performance with 2.5.3 x64 on Win2008 is constantly
> changing, but at best its some 8 seconds and worst even 2 minutes!
> Performance with 1.5.4 x86 on Win2003 is always about the same, and
> always 2.9 - 3.2 seconds.

Are servers (especially the new one) loaded when you perform your tests?
Execution time can sometimes vary in SS due to the GC policy but it
cannot happen for CS, unless there are other queries running at the same
time.

> Query
> ------------------------------------------------
> update X3058000 x
> set
> x.p3058_004n = (x.p3058_004n * 2)
>
> Operations (new Server)
> ------------------------------------------------
> Read : 2.247
> Writes : 5.960
> Fetches: 2.476.240
> Marks : 807.922
>
> Operations (old Server)
> ------------------------------------------------
> Read : 8.516
> Writes : 6.084
> Fetches: 1.602.243
> Marks : 582.584

These numbers suggest that either databases contain different data or
you're comparing SS vs CS, possibly with some concurrent activity.


Dmitry