http://www.perlmonks.org?node_id=998640


in reply to Re: Using a single database handle or multiple handles
in thread Using a single database handle or multiple handles

Newer MS SQL Server drivers (and some other commercial ones) have an attribute called MARS_Connection which when set to 1 enables Multiple Active Result Sets. However, it is generally slower and has a number of restrictions. I wrote a small article on it for DBD::ODBC at Multiple Active Statements (MAS) and DBD::ODBC.