If the problem are the queries performed poorly, there are anyone that
know the complete index list that i must create in my db for reduce this
start-up time ?

Bye,
Enrico Raviglione.


-----Messaggio originale-----
Da: Rhett Rodewald [mailto:rhett.rodewald@...]
Inviato: mercoledì 2 luglio 2003 19.12
A: 'IBObjects Group'
Oggetto: Re: [IBO] Re: FW: IBO seems slower for some things compared
with the BDE



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