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.
--
Bart.
