Subject Re: R: R: R: R: R: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test
Author Robert martin
Hi Enrico

We are using the IBO stuff through our app and had the Boolean problem
initially. I didn't even know about the 'FieldEntryType' stuff. What
we did was.....

Open every DM (100+), Ctrl-F12 to view source, search and replace
TBooleanField with TStringField, Ctrl-F12, Save and select 'Yes to
all'. Although it sounds slow, it only took a few hours (tedious ones)
and it works great. Some code still accesses these fields as .AsBoolean
but that 'just works'. I would give it a go :)

As a question to others, Are you saying that is you have persistant
fields, which don't exist in FB opening a table will be slower? Or am I
misunderstanding that issue?

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Enrico Raviglione wrote:

>Lester Caine wrote:
>
>
>
>>But things will be a LOT faster if you drop the TField stuff. It was
>>intended for migrating applications not for developing them. You should
>>
>>
>
>
>
>>only need legacy components for the occasional connection to a TIBO
>>component. If you want to do EVERYTHING using them then it WILL be
>>
>>
>slow.
>
>
>I know that Lester but almost all my application are ported from a
>previous BDE version then i can't rewrite all my application from
>scratch.
>I know that TIBO are a VCL wrapper of the native TIB component but i
>don't have any performance problem with TIBO component excluded the
>opening time.
>Perhaps if i change all the component with the native one all my
>application perform better ... however the problem at opening time are
>not due to TIBO component.
>
>But what do you think about a solution for solving the Boolean fields
>problem ? Do you have some idea ?
>If anyone can address me to the IBO source where the TIB_Column/TField
>are created the i can try to change something for test this first
>solution on a real application.
>
>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@...
>
>
>
>
>
>___________________________________________________________________________
>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
>
>
>
>
>
>
>
>
>