Ed, (BTW, nice to talk to you again)

I had a very specific experience with this with VFP 3 and AFAIK, 5 and 6 haven't changed the way views are implemented.

I'm confused that you said local-view, instead of remote view. What is a local view for a table on a data server?

My experience was exactly as John had indicated. We had a number of queries bouncing off a table with 40K records. Using remote views, it took upwards of 8 minutes to grab a handful of records, whereas using SQLEXEC to run the query on the server it took seconds... or less.

Am I missing something?