>>>>What kind of database do you have in backend? (if it's Access, for ex, 7
>>
>>>I am accessing a standard table in a Foxpro DBC container through and ODBC
>>connection. You mean that a 7 second requery of the view is ok?
>>
>>Why are you using ODBC? If you switched native VFP table access this should drop to sub second.
>
>I am not sure sometimes VFP6 will be strange it will be more and more a M$ product.
>
>Actually I try to understand the follow.
>
>I have a view with a where condition only on one integer key.
>( NO JOIN CONDITION )
>
>SELECT command to create a read only cursor takes 0.01 sec to retreive 2000 records in a 60000 records VFP table.
>
>The same select in a updatable local view takes 50 seconds for the USE command ?????
>
>No network only a PII266 NT4 64MB
>
>Don't ask me if I have a index on the key...
>
>Rushmore optimization level for table xxxxx : full ( SYS(3054,1) )

When you run select from command window you probably create filtered 'cursor'. Try to issue it with NOFILTER and you will see the difference. Also, what about SET DELETED setting and TAG on DELETED()?
Again, there is no reason to use Remote or Local views returning thoousands of records. The whole idea of view is to return few records.