Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Performance of accessing dataSet fields using Field-names instead of indexes

Is the performance negligible?

For example,

myQuery.FieldbyName("MyField").AsString;
myQuery.Fields[0].AsString;

Cases: Table with a decent number of fields, say > 50 fields

Accessing large resultsets, say > 100,000 rows

Is the readability benefit of field names worth the performance decrease?

like image 323
Simon Avatar asked Apr 27 '11 07:04

Simon


1 Answers

Here is an interesting post by François Gaillard about FieldByName performance issues.

like image 110
kludg Avatar answered Nov 15 '22 21:11

kludg