Subject | Slow FieldByName |
---|---|
Author | Helton de Oliveira |
Post date | 2002-08-19T16:23:21Z |
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
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