Explanation needed (on open and close recordset)

[secretgenius1]

is opening and closing the
ADODB.recordset and
ADODB.connection

for every action(a button click that trigger manipulation to the database) is advisable?

i mean everytime when you want to manipulate or relate to the database , everytime you gotta set up the connection and recordset again and again ..... Wouldn't that slow down the process?


(opinion)

[Abu haider]

For a standard application that deals with the Database all the time, having an open connection is probably the best choice. But if it performs some Database activity only once in a while, it is better to open a connection and free it after you are done.


Now the case will be very different in the case of a Distributed Application. I guess that is beyond the scope of this discussion.