>
>I don't see any reason why all records must be downloaded. Since there is a shared directory, VFP treats the data just like data on a local drive. The network redirector makes things transparent to VFP or other applications that access data over the network (making it look to applications as if they were working with local data).
>
>As to tests, speed tests can give you some strong indication. For example, build a table with a million records, check how long it takes to copy over the network, and how long your query for a single record takes - with, and without, an index. But beware of buffering, which may falsify results. 'Tis best to reset the machine after each phase of the test!
I think what you are saying makes sense. Intuitively (from my experience) I know that downloading records will take considerable time. Maybe he meant that the entire index files will be downloaded to the local PC memory and used to query.
His point was that VFP application create a lot of traffic on the network; because of this "download all records" behavior. I don't know and just trying to understand how things work better.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
