Re: [Openinteract-dev] DB handle caching

[Chris W. <ch...@cw...>]

And...@Be... wrote:
> ...
> anyway: 
> - 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?

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

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

Chris

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