Subject | Re: [firebird-support] Re: Bad surprise on performance |
---|---|
Author | André Knappstein |
Post date | 2015-01-03T10:09:54Z |
>> Operations (new Server)Absolutely the same data in both databases, both definitely on CS.
>> ------------------------------------------------
>> 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.
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 ;-)