> I´ve test a procedure like :
>
> While i< 10000 do
>
> Begin
>
> Select sum(debe)
>
> From apuntes
>
> Where
>
> CodEjericio = :codEjercicio
>
> And Fecha between :fecha1 and :fecha2
>
> And cuenta=:Cuenta
>
> ............................................
>
> End
>
>
>
> This procedure it´s significant slower on FB 1.5

A number of questions:

Did you backup and restore the database under v2.0?

What is the execution PLAN for the statement?

What indexes are defined for the table?


Sean