On Mon, 18 Nov 2002 20:46:09 +0100 Bart Lateur <[EMAIL PROTECTED]> wrote:
> On Mon, 18 Nov 2002 11:11:47 -0800 (PST), Michael A Chase wrote: > > >I'm not sure about Access, but some underlying databases don't like > >multiple statements open at the same time on a single database handle. > >Just for testing, try opening separate database connections for each > >statement and see if that helps. > > > ># For example (untested): > >$sth_a = $dbh_a -> prepare( $sql_a ); > >$sth_b = $dbh_b -> prepare( $sql_b ); > > If that helps, I would cache the SQL strings, not the statement handles, > and use just one $dbh. Why? Database connections aren't that expensive and keeping the statement handles avoids having to re-prepare() the SQL. (We still haven't heard whether using multiple database handles helped.) -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
