Subject Re: [firebird-support] Re: Firebird 2.5 slow script
Author Ann W. Harrison
On 11/18/2010 2:41 PM, jegazarco wrote:
> The only difference on both machines, is that in the one that is slow, i have created the database from an script, while in the other, the database comes from one backup in FB 1.03 and restore in FB 2.5. I will test both cases in my laptop this weekend.
> Anyway is strange that the same script in the same machine, FB 2.1 takes 6 minutes and FB 2.5 takes more than 5 hours.

This is a pretty random thought, but one thing that could cause
procedure compilation to be slow is problems with metadata indexes.
Look in RDB$INDICES to find the names and selectivities of indexes
on the system tables. If they're significantly different in the
two, that may be a clue.

Good luck,