Hi, John
Usually, when we write an application, we connect to a remote datasource when
user starts an application and disconnect when user finishes. Otherwise, we'll get a perfomance problem. Do you think it reasonable to connect just before updates, deletes, inserts, and queries and disconnect immediately after?
>Finally, 80% of the work you do with data should be in a disconnected manner. There are only 4 instances where you need to be connected to the backend data source:
>
>Updates
>Deletes
>Inserts
>Queries
>
>Therefore, if you have 20 or so folks, you may find that at no time, do you have more than 5-8 connections.
>
Igor Gelin
Database Developer