In my application I use a mix of sql passthrough and remote views (like everyone does, I suppose).

The remote views each open a connection when the're USEd.
On a local SQL server ; no problem, but over a slow (dialup) line I have a performance problem : one or 2 views are not a problem, but when I open several, I have a wait time of some seconds, due to the fact that each view opens it's own connection. Can I force them to all the same connection to win time ?