At 02:31 PM 7/7/2003 -0300, you wrote: >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?
I asked this some weeks back. The answer I got was, a database (SQL7 at least) can have around 2.1 million 'objects' (not sure if this was the term used) - those being tables, views, stored procedures, etc etc etc. So unless you've got several hundred thousand tables, I don't think you're in any danger. :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
