Subject Re: [firebird-support] Superclassic slower than Superserver
Author Claudio Romero
Here is testbase.7z (ods 11.1)

http://www.megaupload.com/?d=PH1X8IFH

computer = 3 AMD CPU 4 gb ram
DefaultDbCachePages = 2048
Flamerobin 0.9.3.2077 (64 bits)

Query
SELECT sum(saldo) FROM SALDOS_AFILIADOS = -270860.72

Firebird Versions
Windows = Firebird-2.5.1.26191-64
Firebird-2.1.4.18394-64
Linux = FirebirdSS-2.5.1.26204-64
FirebirdCS-2.5.1.26204-64
FirebirdSS-2.1.4.18398-64


Database ODS 11.1
Windows 7 64 bits
Firebird 2.1.4 SuperServer 64 Bits 179 seg.
Firebird 2.5.1 SuperClassic 64 Bits 198 seg.
Firebird 2.5.1 SuperServer 64 Bits 209 seg.

Slackware 64 13.1 kernel 2.6.33.4 SMP
Firebird 2.1.4 SuperServer 64 bits 177 seg.
Firebird 2.5.1 SuperServer 64 Bits 181 seg.
Firebird 2.5.1 SuperClassic 64 Bits 185 seg.

Database ODS 11.2
Windows 7 64 bits
Firebird 2.5.1 SuperClassic 64 Bits 193 seg.
Firebird 2.5.1 SuperServer 64 Bits 209 seg.

Slackware 64 13.1 kernel 2.6.33.4 SMP
Firebird 2.5.1 SuperServer 64 Bits 181 seg.
Firebird 2.5.1 SuperClassic 64 Bits 183 seg.

- Linux cache is faster than Windows cache
- SuperClassic is faster with ODS 11.2
- Still the best time is for Firebird 2.1.4 SS 64 bits

Regards


[Non-text portions of this message have been removed]