Hi Stephen, I have similar problem. I'm working remotely with mySQL and with this I solve the issue. In my case I perform long long inserts, the last one hold the connection for 2'5 hours without problem inserting 59000 records from the datagrid to one remote mysql.
put "SET wait_timeout=1200" into VarSQL revExecuteSQL MyDB_ID, VarSQL 1200 or higher value, this are expressed as seconds. I got the connection for 20 minutes without any problem. But I prefer open and close when I need. In my case I don't need quickly queries, and only three levels of dependency between queries. Salut, Josep -- View this message in context: http://www.nabble.com/OT%3A-MySQL-Open-Close-question-tp23785007p23823739.html Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
