--- In firebird-support@yahoogroups.com, "Charles-Henri Balet"
<chb-technologies@...> wrote:

>
> Hi all,
> I have installed on 2 same servers one in FB 1.53 and one in FB2.0

and using the

> same database .fdb, the speed is between 10 and 200% slowly on the

FB 2.0 ???

> depend of query or stored proc used !!
> I have read on the quickstart of FB 2.0 that speed was improve on

this new version ?

> But wich speed ????
> I have replace the FB 1.53 with the FB 2.0 on the first server, but

time are same, sure

> that isen't a hardware problem when using same hardware.
> Any has this problem too ?
>
> many thanks for your help
>
> Balet charles-henri
>
>

Hello,
did you calculate statistics using:
SET STATISTICS INDEX <indexname>;
for all indexes ?

regards
PAscal