Hi Sugiarto,

> I use SuperServer mode both in CentOS 6 and Win 7.

> I don't know why performance on CentOS 6 is so bad. I will try again in

CentOS with ext2/ext3 file system, if still no improvement, I will go with
Win7 64 bit.

I have had a look at your database and it looks like you have been testing
on Centos using a page cache of 75 (I suspect you may have classic
installed) - this results in the large number of reads on Centos and
therefore the slower execution/fetch time.
Edit your firebird.conf file (most likely found in /opt/firebird/) and
change the value of DefaultDbCachePages to 2048 (the page cache the super
server is using on your win 7 machine). Also make sure that
DefaultDbCachePages is not commented out (no leading #).

Incidentally, if you are using classic on Centos then a much lower page
cache should also do the trick - perhaps 128 or thereabouts. Below some
results using your database (note that these are for win7 64bit only,
however, Centos 5.6 on ext3 yield identical results)


FB 2.5.1 Super Server/win7-64/page cache=2048
===========================
Current memory = 17762816
Delta memory = 205016
Max memory = 17788936
Elapsed time= 6.53 sec
Buffers = 2048
Reads = 990
Writes 0
Fetches = 8432642


FB 2.5.1 Classic Server/win7-64/page cache=75
===========================
Current memory = 1125288
Delta memory = 205176
Max memory = 1151112
Elapsed time= 23.71 sec
Buffers = 75
Reads = 4244629
Writes 0
Fetches = 8468009


FB 2.5.1 Classic Server/win7-64/page cache=2048
===========================
Current memory = 18029872
Delta memory = 205032
Max memory = 18055704
Elapsed time= 6.42 sec
Buffers = 2048
Reads = 990
Writes 0
Fetches = 8432668


Regards,
David