Hmm... Correct me if I'm wrong, but are you your reports using a dirty read from the database?
By default, sql server locks a record from a select statement. Not good for reporting. If you use appropriate nolock commands in the from clause or SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED you shouldn't slow the application down one bit. Force a dirty read. But I like Dave's suggestion the best... Copy it of replicate it to another server and run reports off of that... That's what we do for some of the more intense reports... -----Original Message----- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 2:15 PM To: CF-Talk Subject: Re: SQL Exactly. Basically if people try to generate reports off of the data, the app slows way down because the tables being used to gather the reporting data are also needed by the application, etc... Mike ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 5:07 PM Subject: Re: SQL > 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
