General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only