AW: [Openinteract-dev] DB handle caching

[<And...@Be...>]

.. well for the stash:

there is a "db-main"=3D>1 added in the KEEP hash, which would explain =
that.
Maybe we added it sometime...
I commented out Apache::DBI in WEBSITE_DIR/conf/apache.dat and in
OpenInteract::ApacheStartup.pm.

-----Urspr=FCngliche Nachricht-----
Von: Chris Winters [mailto:ch...@cw...]
Gesendet: Dienstag, 28. Januar 2003 16:47
An: And...@Be...
Cc: ope...@li...
Betreff: Re: [Openinteract-dev] DB handle caching


And...@Be... wrote:
> ...
> anyway:=20
> - although declaring the new db in the server.ini and adding the =
hopefully
> right datasource parameter to the spops.perl files, the system would =
not
run
> stable, because it tried to find the OI system tables ( like =
sys_error )
> within the new database and vice versa
> - we guessed, that Apache::DBI was causeing the trouble, because it =
could
> not differentiate between the 2 different databases in one mysql =
instance
> - therefore we commented Apache::DBI out and restarted OI
> - now the application works as expected, but I worried about =
performance
> dropping because of not caching the db connections, so I looked at =
the
> connections and saw, that there were still persistent connections =
from OI
to
> the mysql server, which sort of distroyed my beliefs ;-)
>=20
> Could please s.o. explain to me, how this is possilble? Is =
Apache::DBI
used
> at all?

This is odd. I don't think OI is caching these database handles.=20
They're stored in the Stash class during the request and cleaned=20
out at the end of the request. Where did you comment out Apache::DBI?

That said, Apache::DBI shouldn't confuse the database handles=20
since they should have unique connection strings and therefore be=20
separate objects. Can you post the different datasource=20
configuration sections from the server.ini?

Chris

--=20
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.