Michael Tangorre wrote: > > 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...
I'll bite :-) If I understand your question correctly you have some large datasets that is in regular use (transactional as in OLTP), but that is also used for reporting and analysis. And since the reporting takes quite a large time, you are wondering whether it is worth breaking the rules of normalization to add some summary tables to the schema, probably maintained by triggers, so the analysis is a bit faster. Right? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
