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
