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@...]
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@...]
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/