Fixed some syntax errors. > Anyone know the pros and cons of setting up a db connection as > described below? I could not find the info with Google. > > I am setting up a website that will have three separate MySql > databases. Db1 is used in the public area, db2 is used in the value > added area (a visitor is required to obtain a username and password), > and db3 is where the staff maintain the website. From a security > standpoint, does it make any difference if I create one database > connection and call my queries as follows: > <cfquery name="q1" dbname="db1" datasource="theConn"> > <cfquery name="q2" dbname="db2" datasource="theConn"> > <cfquery name="q3" dbname="db3" datasource="theConn"> > > or would this be more secure (three separate connections): > > <cfquery name="q1" dbname="db1" datasource="Conn1"> > <cfquery name="q2" dbname="db2" datasource="Conn2"> > <cfquery name="q3" dbname="db3" datasource="Conn3"> > > Also, which way would be faster? > thank you >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
