At 11:52 AM 9/05/2003 +0200, you wrote:

>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

Cedric:
Since you are testing anyway, I would be interested to see you run this SQL
on the two ODS 10 database servers:

select count(*) from ent_tdv
JOIN lig_tdv
ON
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

I'm curious to know whether the same query goes faster on ODS 10 with
explicit joins than on ODS 8 with implicit joins...because you have such a
large foreign key there, it would be interesting to see the comparative
overhead of one syntax over the other vis-a-vis each of the ODS 10 servers,
too.

Helen


---------------------
See you at the First European Firebird Conference May 19-20 in Fulda,
Germany
http://www.firebird-conference.com