|Subject||Re: Very long prepare time|
> Heiko, on prepare of the first statement metadata casheing islong
> performed. To speed up it on FB1/IB6 and databases with complex
> structure you can create additional indices on system tables, I
> ago usethem
> index IDX1 for RDB$INDICES RDB$FOREIGN_KEY;
> index IDX2 for RDB$RELATION_CONSTRAINTS
> RDB$RELATION_NAME, RDB$CONSTRAINT_TYPE;
> Note this indices don't survive backup/restore, you should create
> manually each time you restore database. In FB1.5 they are realsystem
> indices RDB$INDEX_42 and RDB$INDEX_43.Thanks, Alexander.
> Best regards, Alexander V.Nevsky.
I gave it a try but it doesn't seem to be the problem in this case.
Bad performance didn't change!