Hi Josh,
And maybe what is going on here is the same thing as was happening as told in last month's FPA, where even with nodataonload a query was taking way too long. Turned out to be related, as Ed was getting at, to a (unbalanced) DELETED flag with a tag on DELETED().
In any case the VFUG article asked the reader to 'play along' with something that was hard to play along with. As seems to have been pretty well deduced, VFP with Rushmore may transfer INDEX records but certainly not whole tables (unless, of course, that's how the query resolves).>Ed,
>
>Just to clarify, even a remote view doesn't give you client/server if the back end is VFP, Access, or any other file server based system. I agree that a remote view should run at about the same speed as SQLEXEC(). It sounds to me too like there's something else going on here.
>
>>When you run remote view you really have client-server, and when you use local view you have file server
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only