To commit and close or to not commit and close. That is the question.

[David Cox <david_cox@mac.com>]

I must confess a sin.

Whenever I open my cloud-based MySQL database using the MySQL Community plugin 
I open it is discrete modules (rather than once on app open), read of write the 
data, then end the module i.e. no db.commit or db.close.

Now this has worked fine for me and still does. BUT what is the risk? Does RS 
see that I have opened but not closed the database and close it for me? Am I 
taking memory away in the background leading to a future crash? Will the RS 
garbage collection fix the problem for me?

i.e. must you perform a db.commit and db.close every time before exiting a 
module (assuming you create db in the module)? TIA

David Cox
Holy Mackerel Software

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>