This is a very interesting question. I don't think there would be any performance benefits, although you could setup different datasources for security purposes or for reporting/tracking. Multiple datasources that access the same db, but use different logins for varied access rights. Assign a different datasource to each application and you could track db activity by application.
Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 8:44 AM To: CF-Talk Subject: RE: How many tables per datasource? there is not real answer to that...as # of tables is really based on your database design..for instance we have a database here which is near 500 tables - what would be the point in creating another datasource, imagine all the variables we would have to change! Also, performance is again down to your db design. -----Original Message----- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 13:44 To: CF-Talk Subject: How many tables per datasource? Hi, how's everyone doing? :) I never thought about it until today, when i was asked about it while explaing a bit if mysql for a friend. Is there a rule or best pratice to know when it's time to create another datasource? Maybe spliting 1 datasource with many tables on 2 or 3 increases performance... Regards. BP. _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
