SNIP>>>>
>>>>Then I wonder at the difference between "single chunk" rather than "many small record sized chunks". I assume they'd both amount to the same number of bytes transmitted. Just seems to me that many small chunks could be more network-friendly than a single large chunk. And given HD-level read caching and server OS caching and workstation OS caching and VFP buffering it seems there should be little difference between the two.
>>>
>>>The only real difference I can see here would be one-large-compiled SQL versus lots of interpreted and re-interpreted lines of xbase code.
>>
>>Which should be next to negligible with a 3GHZ processor.
>
>Nope. It will add up if you scan a million rows, versus sql-select a million rows.

Sure it adds up. But a million negligibles is still very small. Not worth worrying about.

>
>>
SNIP