Subject Re: [IBO] Two databases in same project
Author Jason Wharton
The problem is with this statement:

/*---
PREPARE STATEMENT
TR_HANDLE = 14555516
STMT_HANDLE = 14555588

SELECT RDB$FIELD_NAME
FROM RDB$INDEX_SEGMENTS
WHERE RDB$INDEX_NAME = ? /* Name */
ORDER BY RDB$FIELD_POSITION ASC

PLAN SORT ((RDB$INDEX_SEGMENTS INDEX (RDB$INDEX_6)))

FIELDS = [ Version 1 SQLd 1 SQLn 30
RDB$INDEX_SEGMENTS.RDB$FIELD_NAME = <NIL> ]

SECONDS = 0.170
----*/

You must have a LOT of indexes defined in your database. Just for kicks, try
putting an index on the

RDB$INDEX_SEGMENTS

table for the

RDB$INDEX_NAME

column and another index on the

RDB$FIELD_NAME

column.

Let me know how it goes.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com