Daniel,
Thanks for that. I originally tested this several months ago -- and when I
returned to try to isolate this problem (since it was brought up), I was
startled to find that it had disappeared. Unfortunately, my client is
still using Firebird 1.0, but I have moved my developement system to 1.5
for testing. My 3+ minute delay is now about 3-6 seconds. (Using a local
server -- I don't expect the client's network system to be _quite_ as fast)
Kudos to the Firebird team, that little change made a world of difference.

Does anyone know -- can I add indexes to the sytem tables (i.e. Index
RDB$INDEX_SEGMENTS on RDB$INDEX_NAME) in FB 1.0? (I _know_ that's screwing
with system tables... and inherently dangerous), but the potential
performance increase is incredible.
Thanks Daniel,
--Rhett

>
>
> On Sat, 28 Jun 2003 11:41:52 +0000 (UTC), Daniel Rail <daniel@...>
> wrote:
>
>> Hi,
>>
>> At June 27, 2003, 21:30, IB Objects wrote:
>>
>>> I suggest that your database must have a lot of tables/fields/etc and
>>> the
>>> queries I have on the metadata are not so quick since there are no
>>> default
>>> indexes on metadata tables.
>>
>>> Please examine the queries I use in the SQL trace monitor and see if
>>> some of
>>> them are performing poorly. Then, once those are identified, try
>>> creating
>>> some indexes that would allow the server to perform those queries much
>>> faster.
>>
>> Luckily, FB 1.5 now has indexes on the metadata tables. The indexes
>> are only created once the database is restored under FB 1.5. The
>> reasoning to add these indexes in FB 1.5, was for the same reasons
>> that Rhett mentioned. Although, the developer that decided to put
>> them in isn't using IBO, just adding the indices also helped in
>> increasing Firebird's performance.
>>
>>> It would also be useful to make a TI on this so that we can assist
>>> others
>>> who have larger metatada definitions in their databases.
>>
>> It would be useful for those still using Interbase or FB 1.0.
>>
>
>
>