Subject | Re: R: R: R: R: R: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test |
---|---|
Author | Robert martin |
Post date | 2005-05-26T21:28:14Z |
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:
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
>
>
>
>
>
>
>
>
>