Subject RE: R: R: R: R: R: R: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test
Author Enrico Raviglione

At Sunday, May 29, 2005 12:29 AM, Stan Walker wrote:
> When I converted our large app (curently the exe is 13meg) from BDE to
> IBObjects a couple of years ago I also noticed this slow startup time.
> At the time, I considered it almost a show-stopper. However, using the
> SchemaCacheDir saved the day. It only takes 3 seconds for our app to
> come up. The program uses a TIBODatabase component with the
> SchemaCacheDir set to a directory where the exe exists. The exe is on
> a mapped network drive (we have Windows NT) so not only is everyone
> (about 30 users) using the same exe but they are also using the same
> schema.

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
- 47 Procedures
- 663 Triggers
- 141 Generators
- 87 Functions

Best Regards.

Enrico Raviglione

IDEA Sistemi s.n.c.
Via Burolo, 30
10015 IVREA ( TO )
TEL. +39 0125 253235
FAX +39 0125 253271