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

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of Jason Wharton
> Sent: Tuesday, May 31, 2005 4:59 PM
> To: 'IBObjects@yahoogroups.com'
> Subject: RE: R: R: R: R: R: R: [IBO] for Jason: TIBOQuery vs.
> TFIBDataset speed test
>
>
> > This is another issue becuase my application start-up time are more
> > long if i use SchemaCacheDir as also Lester Caine as already
> > verified with my
> > example. Peraphs because in my database there are:
> > - 30 Domains (used a lot in column definition)
> > - 235 Tables
> > - 87 Views
> > - 47 Procedures
> > - 663 Triggers
> > - 141 Generators
> > - 87 Functions
>
> I'm pretty sure this is the root of the problem! I have not
> spent a great deal of time optimizing these aspects as much
> as I have many others.
>
> Jason Wharton
> www.ibobjects.com
>
>
>
>
> ______________________________________________________________
> _____________
> 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
> !
> Yahoo! Groups Links
>
>
>
>
>
>