Subject | Re: [IBO] Two databases in same project |
---|---|
Author | Jason Wharton |
Post date | 2002-01-02T02:23:33Z |
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
/*---
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