When should you use a connect/disconnect ?
At the beginning and at the end of your application or before and after every command ? What are the results towards the server of keeping a connection open like that ? Any comments would be appreciated. I personally think you should connect and disconnect after each command/command group. I'm creating an application with remote views to simulate the real client/server environment and I want to know what the effects will be when I move to a real Oracle server/Sql Server situation.