Hi John,
The book is ADO Examples and Bets Practices, William R. Vaughn,
Page 310..says:
"rst.fields("chaptitleauthor").value
Referencing a field object by name as shown above is the slowest possible
technique. It can be as much as 6 times slowe then refrencing the field object by
number. It is better to use an ordinal reference like
rst.fields(rst.fields.count-1).´value. This small change multiplied by the number of field object refrences, can make a big difference in overall performance..."
The section was looping through the fields object to bind rows to a grid which I normally would never do by name anyways...
But I see your point. I will just make a few tests but if it turns out to
complicate things I definately will forget I read this..
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only