Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Sergey is exactly correct! The view returns the records. VFP sometimes just does a SET FILTER TO when you write an SQL command.
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only