|
[
Permalink
| « Hide
]
Dmitry Yemanov added a comment - 15/Nov/10 08:11 PM
Please provide the script.
The script is prepared for be executed from IBExpert.
I send you the password by email This is my firebird configuration files, that uses port 3053. I have tested the same processs in one machine that only has fb2.5 installed and the performance is good.
Commented by Jesus Garcia:
I have backed up and restored the database and now everything runs fine with good results in compiling stored procedures. Then the problem, i think is with running scripts for creating databases. This is because the restore creates the database with up-to-date index statistics. But with a script, indices on system tables keep having zero selectivity and this causes the optimizer to choose bad plan in the case of one system query, which slows down alterations.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||