> CF 5.0 chokes after trying to do the following (openeing > lots and lots of cfhttps to make static pages from my > product template). I know it's an hard job, but is there > a solution? how can I try and perfom this task without > splitting the records? > > <cfquery name="Generate_pages" .... blockfactor="100"> > SELECT TOP 2000 Product_id > FROM Products > ORDER BY Product_id > </cfquery> > > <cfloop query="Generate_ct_pages"> > <cfhttp > url="http://mydomain/generate.cfm?id=#Product_id#&generate=1"; > method="GET" path="#Map_root#\generate\html\" > file="#Product_id#.html" resolveurl="false" > useragent="CF Fetcher"></cfhttp> > </cfloop>
That's certainly going to beat the tar out of your CF server. If you're going to generate output files from CF, you might do it on-demand, using CFCACHE or your own scheme. If you want to generate them all at once, you might do it externally, using something other than CF to call the pages - you could write a shell script or WSH file to call each CF page and save the content to the file system. Honestly, though, I'd recommend doing this whole process in something other than CF, in this case. I'd rewrite the generate.cfm page in another language, since this is the only script you're running to build your generated HTML. CF isn't really designed to do this sort of thing well - it's really good for doing on-demand work, but not especially good at performing bulk processing. There are lots of alternatives that would work better for this individual task. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
