>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
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108