>>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.
>
>Views can very often make processing faster, especially if you compare a filtered table with a parameterized view.
>
>I suggest you create a parameterized view, where you only fetch the data your application needs, for instance, data for a date range, for a certain client, etc.
>
>HTH,
>
>Hilmar.

Thanks for the suggestion Hilmar. We have narrow 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.