Hi!

What you use in connection, connection string or ODBC data source?
How many views are in the database?
How many views are opened simultaneously? Do you use SHARED option for all views to share the same connechtion handle?

>Is that normal ?
>
>I use Win98, MSDE, Visual Foxpro 7.0. I work with remote views in my application. After creating the connection, and a simple view to specific table on MSDE, the connection to the sql-server is fast. But when developing and testing the application, each time when a view is opened, the "opening" time of the view is a little bit slower (approx. 3 to 5 seconds).
>
>If I delete the connection and rebuild the connection, the "opening" time of the view is fast again.
>
>What can be possible reason for that ?
>
>Bye,
>-Andreas