Aidan: Frankly I am not surprised you are having trouble.... Reports can put a serious load on the CF interpreter. Some questions to ask are: Are you using SQL Server and making full use of its power with views (and calculated columns?), stored procedures, triggers, etc.. Have you considered or have you already created a separate, (repeat separate) OLAP database strictly for reporting? It sounds like you may also have already done this, but have you considered dividing the reports into "regularly viewed" and "must be on-the-fly"? For "regularly viewed" the user could enter their preferred parameters, if any are required, into a database that will store them for use with scheduled reports that could be run in low traffic times and saved to a pick-up location, as, say, pdfs.
There is nothing inherent to cflocating and cfhttp that should take forever..... As a rule, CF does not handle complex reporting jobs well... it is designed to glue things together..... make the work happen elsewhere (for best results)... not meaning to tell you something you already know... sorry if any of this sounds like bad news to you. regards, Patrick At 11:44 AM 31/10/2001 +0000, Aidan Whitehall wrote: >I'm trying to trigger a ColdFusion template that generates a report in the >background. I want to start the process and then redirect the browser to a >"your report is being created" page. Try as I might, I can't get the report >started without the browser being forced to wait at some point for the >report to be finished. > >The report generation needs to be triggered on-demand. Updating a CFSCHEDULE >and then running it straight away doesn't seem to work (I guess because it >must be set at least 15 minutes in the future). > >Calling the report making template via CFHTTP before using CFLOCATION >doesn't work, as the page sits there until the report is finished before >redirecting. > >Using CFHTTP at the end of the "your report is being created" also makes >that page take forever to be rendered. If I was using CF5, I guess I could >CFFLUSH the page before doing CFHTTP last, but we're stuck with v4.0.1. > >I can't call CFML.EXE via a URL and CFEXECUTE is only 4.5+. > > >Any ideas? I've run out... > >Thanks. > >-- >Aidan Whitehall <[EMAIL PROTECTED]> >Macromedia ColdFusion Developer >Fairbanks Environmental +44 (0)1695 51775 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
