The dos table has 21,000 record and memo field.
The size is approx. 29Mb.
I have created dbc but this table is not the part of dbc.

When I create a simple view like
Create SQL View 'Test' as select * from test
and browse this view it takes 78 seconds.
Then I shutdown the VFP6.0 SP3. Restart and use the same table, in command window I type Select * from test.
and it takes hardly 3 seconds.
What is wrong.
I also observed whenever I select a particular field(s) with 'as' say
select first_name as fname last_name as lname from test, then I get a thermometer saying Running Query and takes atleast 3 minutes.

How do I improve the performance using view.
Sanjay Chavda