Nabil,

Every connection you use takes up resources on the server. It is therefore a good idea to use as few connections as possible. The only situation I know of when having multiple connections is a good idea is when you need to execute multiple commands simultaneously. You'll need multiple connections for this because you can only execute a single command over a single connection at one time.

>Per client server application I use only one connection to open all remote views (Share connection), is this OK?
>
>In which cases using more than one connection is adviceable ?