Return as few records as possible.
>
>I have a view that is 20+ times slower to execute using ODBC to a VFP database than a the same view local across the network.
>
>Is this common?
>
>If not, what should I look for to speed it up?
>
>(It was on seven times slower but mucking with the connection seems to have made it even slower)
--sb--