>>I have an app that uses views, the time they take to 'load' and the time they take to update are driving me crazy they are so slow that all users are very angry. Is there any solution to this. Someone can help me please?
>>
>>TIA,
>>
>>Luis Guerra
>
>Are you using parameterized views, or are you bringing the whole table over every time you open it?
>
>What is the WHERE Type set to on you view? If you use Key Fields only updates will happen allot faster. Also, if you update per record rather than per table (if your design allows this) it will seem faster.
>
>BOb


Thanks Bob,
I use the default option in the view desginer I think it is Key fields and modified. I will try your suggestion.
Another problem is the time it takes to load the data. I use parameterized views.

TIA

Luis