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
--sb--