Dawson, Michael wrote: > > We do a similar process with our AS400. Although some of my CF pages do > interact directly with the AS400, most of my data is pulled down to SQL > every night. > > I do this because:
Many of the same reasons we do it. ODBC access to our mainframe (located elsewhere on campus) is considerably slower than jdbc access to SQL Server on the machine sitting next to the web server. Plus, our mainframe has a fairly large maintenance window at night where it is completely offline for several hours, and a LOT of batch jobs run at night too, making access considerably slower "after hours". Most of my stuff is reporting data that is perfectly acceptable for it to be 8-16 hours old anyway. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219614 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
