| Subject | Re: [firebird-support] Re: Firebird 2.5 slow script |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2010-11-18T19:57:11Z |
On 11/18/2010 2:41 PM, jegazarco wrote:
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,
Ann
> 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.This is a pretty random thought, but one thing that could cause
>
> 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.
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,
Ann