>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)