I am posting this again as someone replied without leaving the original message in the reply and now the responses are offbase.
Anyways, the original question was... does anyone have any links or references that will shed some light on breaking an appliction data structure (sql server database) down into transactional and reporting/lookup databases to enhance performance. I am looking for some advantages and disadvantages in doing so, and maybe some examples... Thanks. Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
