I've searched through the archives and can't find a previous answer to my question.
I'm developing a database using VB6 for the frontend and MS Access as the backend. I have been opening my ADO connection(s) to the database in Form_Load and leaving them open until Form_Unload, and then opening one or more recordsets as needed in a given subroutine, and closing these recordset(s) at the end of the same routine.
I've been wondering about the memory and processor overhead of keeping the connections open as long as the application is running like this, and wonder if there would be any overhead advantage of only opening and closing a connection in a given subroutine as required, just as I'm currently doing with the recordset(s).
What's y'all's experience with this, or does it really make enough difference to worry about??