Subject | RE: R: R: R: R: R: R: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test |
---|---|
Author | Enrico Raviglione |
Post date | 2005-05-31T19:05:05Z |
Hi,
now i have modified my most critical application setting
FieldEntryType=[] on my TIB_Connection and set ColumnsAttribute for all
boolean field in all my TIBOQuery.
With this change i have drop down from 30% (on slow PC) to 40% (on more
fast PC) of the opening time.
But this are not so good if i compare them with FIBPlus components...
Please Jason, see if you can optimize IBO or tell me something if i can
do some other things on my code.
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@...
now i have modified my most critical application setting
FieldEntryType=[] on my TIB_Connection and set ColumnsAttribute for all
boolean field in all my TIBOQuery.
With this change i have drop down from 30% (on slow PC) to 40% (on more
fast PC) of the opening time.
But this are not so good if i compare them with FIBPlus components...
Please Jason, see if you can optimize IBO or tell me something if i can
do some other things on my code.
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
>
>
>