I use a TIBODatabase component with the SchemaCacheDir property and
it helps a lot. I don't use a TIB_Connection, so I can't help you
there.

Stan Walker



--- In IBObjects@yahoogroups.com, "Enrico Raviglione"
<e.raviglione@i...> wrote:

> Hi to all,
> I see your discussion about this problems.
> I have the same on my applications (written with TIBO).
> I try to use SchemaCacheDir on TIB_Connection component but without

any

> difference, i must use TIBODatabase for SchemaCacheDir benefit ?
> I see that a lot of startup time (50%) are necessary for fetch the
> Domains definition that i need for TBooleanFields, there are any

other

> method for this kind of fields ?
>
> Peter, if you find any solution please post it, Thanks.
>
> Bye,
> Enrico.
>
>
> -----Messaggio originale-----
> Da: Peter McLeod [mailto:PeterMcLeod@p...]
> Inviato: lunedì 30 giugno 2003 0.49
> A: 'IBObjects@yahoogroups.com'
> Oggetto: RE: [IBO] Re: FW: IBO seems slower for some things compared
> with the BDE
>
>
> Will do,
>
> Thanks Jason.
>
> Regards
>
> Peter
>
> -----Original Message-----
> From: IB Objects [mailto:jwharton@i...]
> Sent: Saturday 28 June 2003 10:30 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Re: FW: IBO seems slower for some things compared
> with the BDE
>
>
> 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.
>
> 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.
>
> Jason Wharton
>
>
>
>

______________________________________________________________________
__

> ___
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
>

______________________________________________________________________
__

> ___
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
>
>

______________________________________________________________________
__

> ___
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
>

______________________________________________________________________
__

> ___
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/