| Subject | Re: Firebird 2.5 slow script |
|---|---|
| Author | jegazarco |
| Post date | 2010-11-14T17:56:30Z |
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
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