>>And for 3 mg RS it takes ~50sec.?
>>Mark
>
>That's correct, conversion took 51 seconds on a PII 266 test machine. Performance may vary depending on the record width, field count but the bottom line is conversion is extremely slow when considering only 3 Meg of data is being translated from RS to cursor. I have not yet tested moving from cursor to RS but I expect similar results.
>
>I guess I will continue to do intensive data processing at the recordset level when large conversions are impractical. This bites when I know that using VFP's native data manipulation commands would be simpler to code and run much faster than using ADO's limited data functions combined with record level processing.
Realize that in many circumstances it may be much faster to use a
VFP ODBC driver connection to assemble the recordset rather than using
VFP natively then converting to a recordset. IOW, use ADO natively
rather than using VFP syntax.
I think you're a little to overeager with these tools. They have their
place, but they shouldn't overshadow of why you use ADO in the first
place.