-----Ursprungliche Nachricht-----
Von: Helton de Oliveira [mailto:helton_o@...]
Gesendet: Mittwoch, 21. August 2002 14:22
An: IBObjects@yahoogroups.com
Betreff: Re: [IBO] Slow FieldByName


*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi Jason,

Yes, i can reference the fields by local variables, but is much easier to
use FieldByName instead of this method.

As the TIB components are supposed the be faster than the TIBO ones do you
intend to improve the FieldByName function in a TIB_Cursor like in the TIBO
components ?

Thanks,

Helton

>Jason wrote:
>

> In the TIBO... components for TDataset a person made it so that

FieldByName

> started the scan if fields with the next field from the last one found
> instead of the first field. This made it more quick for people doing
> FieldByName that corresponded with the numerical order of the fields.
>
> What I recommend people always do if possible is to do FieldByName outside
> of the loop and store aside the direct object reference in a local

variable

> and make reference to it directly instead.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> -- We may not have it all together --
> -- But together we have it all --
>
>
> ----- Original Message -----
> From: "Helton de Oliveira" <helton_o@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, August 19, 2002 9:23 AM
> Subject: [IBO] Slow FieldByName
>
>
> > Hi,
> >
> > I need to get a field value by it's name. When i use a TIBOQuery, it

took

> an
> > average of 30 miliseconds to get the field value of 10000 records with

the

> > following code:
> >
> > Value := FieldByName('SomeField').Value;
> >
> > If i use a TIB_Cursor, it gets an average of 300 miliseconds to do the
> job.
> > About ten times more than the TIBOQuery with the same code !!
> >
> > Why the TIB_Cursor's FieldByName method is so slow ?
> >
> > Is there any other method of catching the field value by it's name other
> > than FieldByName ? I already tried the FieldValue method with similar
> > results...
> >
> > Thanks in advance,
> >
> > Helton

___________________________________________________________________________
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 !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/