>>>> I was having some performance problems with VFP5 using Views to load a
>>>> form. I tested the performance of the view "requeries()" on the network vs
>>>> the local drive. Over about 7 different views I found the total time to
>>>> retrieve them from the net took 6 TIMES LONGER than from the local drive.

>>>4) ensuring that the queries are as optimized as possible. This means
>>>checking the indexes on the tables to ensure that every field in the
>>>WHERE and JOIN clauses is indexed (including DELETED()), possibly
>>>breaking a single large SELECT into multiple smaller and more efficient
>>>ones. Also ensure that a SELECT into a cursor actually puts the results
>>>into a cursor, rather than just filtering the original table (use the
>>>NOFILTER clause).
>>>
>>>HTH
>>>
>>>/Paul
>>
>>Thanks for the advice. I should clarify some of the specifics about what I am doing. I am running everything on a local drive (i.e. executable, tempfiles) except the DBC and the tables. I am using local views. I am not joining anything on the example I supplied, its a single table view. I will try indexing on the two fields I have in my WHERE clause to see if that helps. That would not explain the difference in retrieval time from the local drive to the net, since both tables (local and network) were not indexed on these fields. So I guess I am wondering if I can expect a 6X increase in retrieval time on a network vs a local drive?
>>
>>tc
>
>The indexes will increase performance since without them the query has to transfer the entire table across the network to select the result rows. Unless you have a realy fast network connection, the local drive will always be faster. My local drive can transfer 3.4 MB/Sec, a 10BaseT connection has a maximum bandwidth of 1.2 MB/Sec. In reality you will never see this performance from the network because of the overhead on packets, other users sharing the bandwidth, and the overhead of the servers talking to each other.

The indexes worked as yourself and Paul suggested! Thank you again for the advice!
Question...Does rushmore also work on HAVING clauses in the select statement? What about in GROUP BY and ORDER BY clauses?

Thanks again, this was a real life saver!

tc