>>We don't really have defined views, instead we create the views on the fly and these temporary views are stored in their own temporary database. We've tried having the exe and the temporary dbc on the local machine and the performance degradation is still the same.
>
>Ramil,
>
>Are these temporary views used for updating data or just for reading? If the latter, then you could always create SELECT statements that generate cursors you could work with, which would probably perform better.
>
>Laterness,
>Jon

We use the views to update the data as well.