--- In ib-support@y..., "Todd Brasseur" <todd.compass-cama@h...>
wrote:

> The first
> time I run the SQL (after a reboot) it takes approx. 2.5 seconds to
> run. After the first time it is almost instantaneous.

...

> My worry is that things are taking along time because I have so many
> Foreign Keys defined (some with cascade update and delete and some
> without). This is a fairly large and complicated database. I am
> thinking about removing all Foreign Keys and replacing them with
> triggers but this is going to be quite onerous.
>

Hi, Todd. I re-post my own message made some days ago in the thead
with similar subject name :)

Try

CREATE INDEX RDB$INDICES_IDX1 ON
RDB$INDICES (RDB$FOREIGN_KEY)

greatly improves prformance on first execution of selects. In my case
(about 800 ref_constraints, 2000 indices) - 20 times.

But don't forget re-create this index after backup/restore - it will
disappear.

Best regards.