Thank you very much Daniel,
i don't know that TIBOQuery.ColumnAttributes are usefull also for
TFields.

With this suggestion i can modify my most critical application, set
FieldEntryType=[] and see what happen.

If i halve the opening time then i can give to my customers a first
answer to they request. But i think that there are some other
investigation to do for speed-up moreover the opening time.

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 Daniel Rail
Inviato: venerdì 27 maggio 2005 13.05
A: 'IBObjects@yahoogroups.com'
Oggetto: Re: R: R: R: R: R: [IBO] for Jason: TIBOQuery vs. TFIBDataset
speed test


Hi,

Here's my experience.

At May 27, 2005, 06:50, Enrico Raviglione wrote:

> also for me 3rd compatibility with Infopower and other VCL components
> is a must-have. Some question now for investigate:
> 1) you don't have any performance problem at opening time also if you
> try to open some query with a lot of fields ?

I only have a 3-5 seconds delay when opening the application, also this
particular application uses packages and a plugin architecture. And, it
doesn't matter how fast the computer is(the slowest being a PII 233Mhz
with 128MB RAM). And, the database has 220 tables, some tables do have
close to 60 fields(average would be 20), 42 domains, 11 views, 104 SPs,
239 triggers, 174 generators, 75 UDFs.

> 2) in your database design do you use a lot of DOMAIN definition or
> none ?

I have 42 domains.

> 3) do you use TBooleanFields ?

Yes. And sometimes, I use those fields as is.

> You have set FieldEntryType = [] or
> FieldEntryType = [fetDomainName] in your Connection component?

FieldEntryType=[]

When I define the TIBOQuery, I go in the ColumnAttributes tab in the
query editor and specify that the field is a boolean and what are the
checked and unchecked values are. Also, with Infopower you can use the
field as is, and specify the Checked and Unchecked values directly in
Infopower's components.


--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.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