in reply to Re: Perl DBI execute statement
in thread Perl DBI execute statement

I think *all* DBD's allow multiple select handles running at the same time on the same database handle. Some DBD's however do not allow two handles on the same table running simultaneously. Other DBD's do not allow mixing simultaneous handles on the same table that alter the table, like select+delete, select+update, update+delete, select+insert, update+insert, insert+delete etc. Most likely it is not the DBD that imposes these restrictions, but the (commit model of the) underlying database.


Enjoy, Have FUN! H.Merijn

Replies are listed 'Best First'.
Re^3: Perl DBI execute statement
by afoken (Chancellor) on Dec 16, 2016 at 20:31 UTC

    Last time I uses DBD::ODBC with MS SQL Server 7 and 2000, only one statement could be active at any time, due to protocol limitiations of the MS SQL Server and its predecessor Sybase.

    The protocol has been "extended" (or should I say botched?) since then to allow a complete different way for other SQL statements to execute in parallel to the main statement (I think this is called MARS). See DBD::ODBC::FAQ and http://www.easysoft.com/developer/languages/perl/multiple-active-statements.html for the ugly details.

    Alexander

    --
    Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)