I wish that was the case... gosh I wish that was the case. :-) However, the larger tables have so much activity due to the need to update the status of each record to one of 4 values until it reaches a status of final.... So essentially we provide "live" tracking of jobs that the application handles.
I just came aboard at the company for one main reason, to evaluate the current application, rewrite it for MX, and document it (compund reason). Part of the rewrite involves identifying problems with the data structure, and this is the big one. My initial thought was to read up on replication and apply snapshot replication to the tables in which a daily update to a reporting database would be sufficient, and then to use transactional replication on the tables for which we need "live" reporting. I am not sure if that is possible yet or a good idea if possible. At anyrate, that is the issue. Mike ----- Original Message ----- From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 5:24 PM Subject: RE: SQL > > 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... > > Is it absolutely necessary to run the reports off of the live data? If you > can run reports off of, say, yesterday's data, you could build a mechanism > to export data from your OLTP database to an OLAP database. Then, your > reports can run without affecting your live system at all. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
