Subject Re: [firebird-support] Re: Bad surprise on performance
Author André Knappstein
>> 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.


Absolutely the same data in both databases, both definitely on CS.
Table specifically created for testing with absolutely the same
records and subsequent identical DML commands and commit intervals.

Will repeat the same test later, now with re-configured RAID
cache.
Right now my wonderful wife is already tapping her foot to signal the
start of a shopping tour. And, trust me, this can be more dangerous
than an inefficient FB server ;-)