Hi,

I come back to you about my question about choice of Interbase/Firebird for our new product.
We have to migrate our IB 4.2 to IB 6.5/7.0 or Firebird.

I made a lot of tests to compare results and it appears that IB4.2 is a lot more performant than IB6.5 and Firebird in READ mode
Is this normal ???

Here is the benchmark :

Table ENT_TDV : 194016 records
Table LIG_TDV : 584063 records

select count(*) from ent_tdv,lig_tdv
where ent_tdv.soc_c_code = lig_tdv.soc_c_code and ent_tdv.exe_i_num = lig_tdv.exe_i_num
and ent_tdv.sou_c_cod = lig_tdv.sou_c_cod and ent_tdv.etv_c_numticket = lig_tdv.etv_c_numticket

Records count : 584063


Interbase 4.2 with ISQL :
(page size DB = 1024)
First execution : 00:00:42
2nde excution : 00:00:16
3rd execution : 00:00:16

Interbase 6.5 with IBConsole :
(page size DB = 1024)
First execution : 00:00:24
2nde excution : 00:00:24
3rd execution : 00:00:24

Firebird with IBOConsole :
(page size DB = 1024)
First execution : 00:01:04
2nde excution : 00:00:24
3rd execution : 00:00:24

Firebird with IBOConsole :
(page size DB = 4096)
First execution : 00:00:50
2nde excution : 00:00:31
3rd execution : 00:00:31


--------------------------------
Cédric Joubert