Here the result of speed test without TBooleanFields and FieldEntryType
= []

On my PC opening time are decreased from 12 sec. to 6 sec.
On a Celeron PC opening time are decreased from 29 sec. to 15 sec.

Then this would be the first "big" performance issue.

I don't know how FIB make the test for define TBooleanFields but also
FIB use DOMAIN for this.

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






-----Messaggio originale-----
Da: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Per
conto di Enrico Raviglione
Inviato: giovedì 26 maggio 2005 12.46
A: 'IBObjects@yahoogroups.com'
Oggetto: R: R: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test


Hi to all,

now i'm go to change my example without the use of Boolean fields,
setting FieldEntryType = [] and then i send you my result.

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




-----Messaggio originale-----
Da: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Per
conto di dmarmur2002
Inviato: giovedì 26 maggio 2005 11.54
A: 'IBObjects@yahoogroups.com'
Oggetto: Re: R: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test


Enrico, Lester, Jason...

Well, I suggested this just as something to test to get at the speed
issue.

If you look at function GetColAttrTxt in IB_Components.pas you'll se
that if a fieldname search fails in the dataset stringlists it goes on
to the stringlist of the connection. If that fails too the search for
SQLTypes is done in the connection stringlist and finally the serach for
domain name.

If you have a lot of information in FieldsXXX stringlist of the
connection and you prepare a query where most fields do not have a
FieldsXXX entry (most lists are searched this way) then an extra search
is done. Two if your setting is [fetSQLType, fetDomainName].

Understand that the search is done multiple time for each field. Exactly
how many times depends on your setup and how IBO accesses these
stringlists during the operations you perform.

Since the search is done on each access of each of the FieldsXXX
stringlists this may amount to a lot of processing.

Could you not just temporary ignore the BOOLEAN thing just so we can see
if it gets any faster? And by how much.

Regards,

/Dany

--- In IBObjects@yahoogroups.com, "Enrico Raviglione"
<e.raviglione@i...> wrote:

>
> >
> >IBO searches in metadata for Domains and SQL types after a miss on
> field name. That creates two extra searches (alas >in memory) per
> operation on fields without entries.
> >
> >Is FieldEntryType set to anything? If it is try setting it to [].
> >
>
> FieldEntryType = [fetDomainName]
>
> I need to use Boolean then i don't know any other method for do

that.

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

________________________________________________________________________
___
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








________________________________________________________________________
___
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