Thank you Dmitry.
Seems I found the solution to the real problem parallel to your
posting of the message (BBU failure report resetting cache parameters).

The difference on old hardware (2.9 - 3.2) seconds probably is due to
inaccuracy in the very simple test methods. And, yes, nobody was
currently working on the old hardware, but there still are some 400
fb_inet processes active, which probably added to the inaccuracy.




=====================================================================
Ihre Nachricht:

> 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




> ------------------------------------

> ------------------------------------

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu there.

> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------

> Yahoo Groups Links