> I'm open to any suggestions, but for now it looks like the > two-connection approach solves my problem.
You never stated the problem you are trying to tackle with the two connections. :) On 16 January 2014 14:23, Dave Howorth <dhowo...@mrc-lmb.cam.ac.uk> wrote: > Lianna Eeftinck wrote: > > Just curious, why would you want to make two connections to the same > > database with only a difference in the mysql_enable_utf8 option? It is > > generally a bad idea to open more than one connection to a database > because > > you might find updates in one are not showing up straight away in the > > other, such as when transactions are involved. It also takes more > resources > > on both sides. > > It's read-only access to this database, so there's no risk, and I don't > think two connections rather than one is likely to lead to a resource > problem. > > > UTF8 and string encoding options can probably be handled in other ways > from > > one and the same connection. > > I'm open to any suggestions, but for now it looks like the > two-connection approach solves my problem. > > Cheers, Dave > > PS Thanks to everybody else who replied. > > _______________________________________________ > 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/dbix-class@lists.scsys.co.uk >
_______________________________________________ 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/dbix-class@lists.scsys.co.uk