Whoops.

Sorry I thought this was in the IBO list. Sorry. However if you are
using IBO components perhaps you should post a question there.

Rob Martin
Software Engineer

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

Wild Software Ltd



Robert martin wrote:

>HI
>
>Our apps use FieldByName / ParamByName exclusively, its a style
>guideline here (and a good one). We have never tried testing the
>performance but I do recall Jason saying there was a performance
>difference and he was looking at improving / had improved the source
>code (which wasn't as good as it could be). Hope I am not miss quoting him.
>
>Anyway we decided to take the performance hit and wait. Perhaps Jason
>can confirm, I think I recall reading it had been done?
>
>Rob Martin
>Software Engineer
>
>phone +64 03 377 0495
>fax +64 03 377 0496
>web www.chreos.com
>
>Wild Software Ltd
>
>
>
>Grant Brown wrote:
>
>
>
>>Hi Adam,
>>
>>
>>
>>>>I doubt it is noticeable. They tend to be very small lists and are
>>>>kept in memory, so each search is at worst n complexity.
>>>>
>>>>
>>Not so sure about this, on our core product SiteDoc we first had all
>>querys as per you suggestion using the FieldByName etc and we then
>>changed them as per below and the difference in performance was just
>>amazing - boy did it speed things up.
>>
>>
>>var
>> T: Integer;
>> FieldArray: array[0..1] of TField;
>>begin
>>
>> try
>> LoadQuery.Params[0].AsInteger := MyIDNumber;
>> LoadQuery.open();
>> FieldArray[0] := LoadQuery.FieldByName('XXXXaaaa');
>> FieldArray[1] := LoadQuery.FieldByName('XXXXaaaa');
>> while not LoadQuery.eof do
>> begin
>> MyItem_1.Text := FieldArray[0].asString;
>> MyItem_2.Text := FieldArray[0].asString;
>> LoadQuery.Next();
>> end;
>> finally
>> LoadQuery.Close();
>> end;
>>
>>
>>
>>
>>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>