By default, the UPDATE statement generated by the View Designer uses "Key and modified fields" so that you could get a SQL UPDATE statement that includes the memo field in the WHERE clause. This will greatly slow down the statement.
On the Update Criteria tab of the View Designer, you may want to change the SQL WHERE statement to Key fields only.
>Hi Craig,
>
>We have zoom down to the views that is updating memo text. Disabling the updating of the memo fields, increases the speed tremendously. Any tips to increase the speed.?
>
>Regards.
>
>>What part of the view is slow? Retrieving data? Updating data?
>>
>>
>>>Hi all,
>>>
>>>Our previous version of app was running against VFP tables. We have converted to use views and the processing is sluggish after the conversion. What are the causes for this? Where I should start looking to improve the speed?
>>>
>>>Thanks in advance.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer