my question that i can't find an answer to
when you make connections
is the general rule one query for one connection ???
i've tested and it's possible to do many query for one connection
what is the downside of making new connection every query you do
what is downside of making one connection and using it for multiple queries
what is the standard usage ???
thanks for answer
The general rule is to get, use, and release a connection, statement, resultset, whateverSQLresource, in the most local manner reasonable.