Write flat files based on HUGE query
I have a huge query that takes about 15 minutes to run. I'm a small college, and I'm pulling data on my faculty and their class schedules, office hours for posting on the web site. My legacy administrative database was never designed for servicing the web, and it is just a terribly long request to get all of this data. Currently, I'm caching the query for a week, and that seems to work pretty well. However, I'm getting requests for changes to this application, and I'm considering a re-write. One of the ways I'm thinking about doing this is to run my mongo-query, and then loop through the results writing html, or cfm, files as I go. It would probably be about 300 pages. Is it like this: cfoutput query=mondoQuery cffile !--- set filename to #mondoQuery.id#.cfm --! !--- All my html, cfm, javascript, etc. for that ID --! /cffile cfoutput Is that the best way? Advice? Willy Ray Web Applications Developer Westminster College __ Dedicated Windows 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=coldfusiona 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
RE: Write flat files based on HUGE query
I think you should look at solving your backend problem first - perhaps a data export to a different rdbms , or perhaps you should be running more, smaller queries. The paging thing would probably work, but I'm guessing it would be clunky and it would cause some of the same problems you have now (data not up to date etc.). -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 7:38 AM To: CF-Talk Subject: Write flat files based on HUGE query I have a huge query that takes about 15 minutes to run. I'm a small college, and I'm pulling data on my faculty and their class schedules, office hours for posting on the web site. My legacy administrative database was never designed for servicing the web, and it is just a terribly long request to get all of this data. Currently, I'm caching the query for a week, and that seems to work pretty well. However, I'm getting requests for changes to this application, and I'm considering a re-write. One of the ways I'm thinking about doing this is to run my mongo-query, and then loop through the results writing html, or cfm, files as I go. It would probably be about 300 pages. Is it like this: cfoutput query=mondoQuery cffile !--- set filename to #mondoQuery.id#.cfm --! !--- All my html, cfm, javascript, etc. for that ID --! /cffile cfoutput Is that the best way? Advice? Willy Ray Web Applications Developer Westminster College __ 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
Re: Write flat files based on HUGE query
you could use cachedwithin() attribute in you query tag. On Tue, 5 Feb 2002, Willy Ray wrote: I have a huge query that takes about 15 minutes to run. I'm a small college, and I'm pulling data on my faculty and their class schedules, office hours for posting on the web site. My legacy administrative database was never designed for servicing the web, and it is just a terribly long request to get all of this data. Currently, I'm caching th e query for a week, and that seems to work pretty well. However, I'm getting requests for changes to this application, and I'm considering a re-write. One of the ways I'm thinking about doing this is to run my mongo-query, and then loop through the results writing html, or cfm, files as I go. I t would probably be about 300 pages. Is it like this: cfoutput query=mondoQuery cffile !--- set filename to #mondoQuery.id#.cfm --! !--- All my html, cfm, javascript, etc. for that ID --! /cffile cfoutput Is that the best way? Advice? Willy Ray Web Applications Developer Westminster College __ 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
