search for: ensurerefreshcon

...S-DBI driver: (¸/&cannot allocate a new connection -- maximum of 16 connections already opened) So this means I need better control over the MySQL server connections within my R API. I could execute SQL statements, and go into the system but would prefer to stay within R if I can...A function EnsureRefreshCon would be my ultimate goal. Perhaps a CleanServerConnections too? I need some examples to get my head around this code. So.. a long running algorithm might need to go away from MySQL and come back, but by then the connect is orphaned? Any pointers? (I have read the R-MySQL doc and a slide presen...