On Fri, Feb 11, 2011 at 7:20 PM, Trevor Leffler <[email protected]> wrote:
> Hello, > > I am investigating whether DBIC has support for switching between logical > databases (ala 'use db1; ...; use db2; ...;'). I've a situation where there > exist many cloned databases (same DDL), one per customer. The current model > is that all customers share the same front-end, and it switches between DBs > as needed. I would like to avoid the following: multiple open connections > per app process, Do you mean by this that you are keeping connections open between requests? (I'm assuming you're talking about a web app I guess.) Have you tried just connecting every time instead? On some databases this is not a heavy enough operation to justify the work you will do to keep everything straight, make sure the connection hasn't timed out, etc. That can be hard stuff to debug. I'm just saying maybe it's premature optimization if you don't know whether connection time is a bottleneck. mike > multiple MyDB::Schema objects, server hups upon customer adds/drops, etc. > >
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
