Hi,

Normally i make a connection as follow :

1) Open one connection to the database and reuse the connection all the time until i exit the system.
2) Open connection to the database, close the connection when the query finish, reopen again the connection for another query and close it when finish.
May i know which one is better for performance and which one is suggested to be used and what is the pro and cons?


Thank you very much.
regards,

florence