Leonardo, Do you mean spilt the database itself up or just have two datasources pointing to the same database? There should be no performance issue based on the number of tables within a database, unless you are trying to call data from all at once(then again, that really wouldn't work unless you built it that way to begin with, and that alone would cause lots of problems).
Dave -----Original Message----- From: Leonardo Crespo [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 1:32 PM To: CF-Talk Subject: How many tables a datasource can handle? I'm wondering when it's time to split a datasource that has many tables into two or more. I never saw an article or recommendation on this. Anyone knows if the number of tables can decrease performance? Regards, Leonardo. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4