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"" datasourcet="theConn"> <cfquery name="q2" dbname=db2"" datasourcet="theConn"> <cfquery name="q3" dbname=db3"" datasourcet="theConn"> or would this be more secure (three separate connections): <cfquery name="q1" dbname=db1"" datasourcet="Conn1"> <cfquery name="q2" dbname=db2"" datasourcet="Conn2"> <cfquery name="q3" dbname=db3"" datasourcet="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:324084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
