Funny, I was thinking about something very similar last night and found myself wondering if there was a good portal type resource focused on enterprise strategies and CF. Specifically how to properly architect your new site that you know (hope) will end up with millions of records and millions of views. Using multiple databases to spread load, etc. There are lots of good nuggets around, and certainly a lot of valuable information to search within cf-talk, but is there a site focused on the topic and organizing the information?
On 2/21/07, Ian Skinner <[EMAIL PROTECTED]> wrote: > > I have an issue that I could use some advice on how to best resolve. > > This is a calendar report that shows a summation of daily transactional > data. Three times daily processes in the oracle database fire off that > aggregate and sums this information for use by this report. These processes > take about 90 minutes on average to run and while running accessing the data > is hit or miss. In between these updates the data does not change. > > My idea is to cache this data in the CF report application and only update > the cache after the update process has finished. I already have the hook to > do this. The process remotely contacts a CFC when it is finished. But how > do I best to cache this data? There are tens of millions records covering a > decade of data past and up to a year into future. So it seems a bit > impractical to put all that into memory! > > The current month's data is by far the most frequently accessed. I would > suspect that including the past and future 2 or three months would cover > better then 95% of the usage. > > How might some of you better n-tier types tackle this kind of > problem. I'm sure I have not provided enough details here. I am not even > sure what is relevant to tackling this issue. > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > --------- > | 1 | | > --------- Binary Sudoku > | | | > --------- > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270356 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
