>Hi all
>
>I encountered very slow performance when I open a VFP9 remote view with memo fields. It can take 2 minutes or more to open a view with 6000 records. Is there a way to improve speed when opening a VFP remote view containing memo fields (ntext, nvarchar(max))?
>
>Your advice much appreciated.
>
>Thanks & Best Regards
Perhaps set FetchMemo property of the view to false
See help (1) dbgetprop() and (2) Optimizing Access to Remote Data
Gregory