I always suggest people look at the performance monitor/SQL trace because
the query requesting that information may not be working optimally and the
addition of an index on the server could greatly increase the performance if
there is a lot of data in the system tables. Watching the SQL trace will
reveal where the time lag is at.

Jason Wharton
www.ibobjects.com

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Enrico Raviglione
> Sent: Tuesday, May 31, 2005 12:31 PM
> To: IBObjects@yahoogroups.com
> Subject: RE: R: R: R: R: R: R: [IBO] for Jason: TIBOQuery vs.
> TFIBDataset speed test
>
> Hi Jason,
>
> some good news for you (and also for me :-> ).
>
> Now with my modified application (FieldEntryType=[] on my
> TIB_Connection) i have try to set SchemaCacheDir, then ... with my big
> surprise, the opening time are reduced of another 40% - 50%.
>
> If i active SchemaCache with FieldEntryType=[fetDomainName] my
> application are more slow than without SchemaCache, but setting
> FieldEntryType=[] my application are more fast with SchemaCache!!!
>
> Perphas fetch Domains are not optimized ...
>
> Best Regards.
>
> Enrico Raviglione
>
> IDEA Sistemi s.n.c.
> Via Burolo, 30
> 10015 IVREA ( TO )
> ITALY
> TEL. +39 0125 253235
> FAX +39 0125 253271
> www.ideasistemi.it
> e.raviglione@...