İs it better in VB to :
1.open a connection and use it every time to access a db and close it when we exit the program
2.open a connection when we need to access the db and close it when we finish our job.(Making several open-close connections inside the program)
Which one is better for the performance?