Hi Sergey

Doesn't seem to matter if I have 6 or 115 records.

Strangely enough similar remote views accessing the primary table are fast. Has got to be something to do with the link. The local view is very quick, less than one second.

While the records are large they are no larger than other remote views access the same primary table.

Wll keep looking.

Any chance of chatting on MSN about this? (yotta255@hotmail.com)

regards
Geoff Scott




>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)