> I have tested more in depth fb 2.5 and i have seen speed problems
> compiling stored procedures.
>
> The database has 1000 tables, 229 views, 1400 stored procedures and 3100
> triggers.
>
> The compiling time between fb2.1 and fb2.5 for triggers are the same,
> but when compiling stored procedures, while fb 2.1 takes less than one
> second, the same stored procedure in fb2.5 takes between 10 and 15
> seconds. I have tried the same using isql and ibexpert with the same
> results, but as i said in the first post, when creating the database
> from the script i notice that performance problem, starting the
> procedures compilation.
>
> Regards
>

I can not confirm this. Firebird 2.5 64bit SS on Windows 7.
My Db is a lot smaller than yours, 177 tables, 26 Views, 295 Procedures,
275 Triggers, 67 Generators, 6 Exceptions, 4 UDF's, 5 Roles and 382
Indices.
It takes 50 seconds to create this from script, and I have not noticed any
change from 2.1.

And recompiling procedures is as fast as ever.

Maybe the creation is slowing down as the number of objects increase.
--
Mvh
Trond Dammen