You can't expect to get 214,000 records across the LAN cables fast <g>.

The pat answer is use a parameterized view and only let the users get what they want to see.

>>Try to run Select * From lrs!Names NOFILTER and compare results.
>>
>>>I have a local VFP table of about 214,000 records. When I execute a simple SQL on it in the command window. “Select * From lrs!Names”, it return all of the records in about 1 second.
>>>
>>>When I create a local view with no filter and no sort it takes at least 60 seconds.
>>>
>>>When I view the SQL generated by the view, It reads exactly like the one I typed in the command window: . “Select * From lrs!Names”.
>>>
>>>Why is the local view so much slower than the typed in SQL?
>>>
>>>TIA
>
>Thanks for replying Sergey.
>
>Looks like the NOFILTER will make the SQL statement as slow as the view but I'm looking to make the view as fast as the SQL statement. Is there anything I can do to speed it up?
>
>Thanks again