Say that you have an application that makes a couple of calls to the same database (insert, uppdate and delete). Do I need to close the connection between every call or can I make them over the same connection?
I know that it is possible but cloud there be an issue in doing so?
Yes, but if I’m going to transfer say 100 rows from one table to another that’s 100 connect and 100 close. It would be better if i cloud use the same connection, it would use less resources. But if in doing so it creates error of some sort than i must close it for every insert.