[Openinteract-dev] DB handle caching

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

Hey y'all,

we just fell over s.th. strange, that I hope you knowing mailing list
readers are able to resolve:

- we use a variety of mysql and oracle databases under OI with one db =
on
each host, so far
- on our test system we tried to imitate this by separating tables to
multiple mysql database within the same db instance
- our aim with this is to separate the tables of each major application =
to
one database

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 ;-)

Could please s.o. explain to me, how this is possilble? Is Apache::DBI =
used
at all?

thanks for your time,


Andreas Nolte
Leitung IT
-----------------------------------------------------------
arvato direct services=20
Olympiastra=DFe 1
26419 Schortens
Germany
http://www.arvato.com/

and...@be...
Phone   +49 (0) 4421 - 76- 84002
Fax	+49 (0) 4421 - 76- 84111