Hi Charlie,
>I just ran a simple select * query in the Query Analyzer. It reported an execution time of 00:00:04. I ran the same query in VFP and it was so fast it wouldn't even register on the clock.
I bet what you did was to create a filtered result set in VFP. You can't compare this time with the time SQL server needed, because in this case VFP only transfers those records across the network that are currently displayed in the grid or BROWSE.
Christof
--
Christof