>Thanks, but I don't think that is it: all views use the default Fetchsize value...
>
>If you consistently open remote views with the handle rather than the string, is there a limit to how many can be opened on one connection? or does VFP take care of this automatically?
I don't see why there would be any limit - VFP is single threaded, so any request sent to SQL would still have to wait, i.e. VFP won't attempt to send two requests at the same time. So... if it can't do more than one at a time, it doesn't matter for how many does it use it.