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..
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement