>I was reading that accessing a field object by ordinal is 400 % faster..
>
>For example:
>
>oRS.fields("name").value
>vs
>oRS.fields(0).value
>< snip >
I have to agree with John P here that the speed advantages may not be enough to account for the added code complexity and maintenance headaches in the future.
As per using ordinals, what I've done in some websites I wrote (ASP+VBS) is to convert the recordset to an array then traverse the array to create my report output:
oRS.MoveFirst()
aMyArray = oRS.GetRows()
...
...
for i=0 to UBound(aMyArray,2)
'do whatever here...
next
HTH