>Hi Marcel,
>
>>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 ?????
>
>Sounds like the SELECT statement is creating a filtered table, while the view is actually downloading the records (though, 50 seconds seeems to a big numbr, unless you have a very slow network). Try adding NOFILTER to the select. This gives you the time, the view should take.
>
>Christof

Hi Christof,

Yes that's it ( no temporary table is created on disk )

The network is not very slow it's on a local disk .
But the memo file is very large ( 100 MB )

Tks
Marcel