Michael:
I read your question and it is not entirely clear but I get the general
drift. What you are asking suggests that the architecture of what you are
doing is unweildy.
Not to be annoying, but you are asking ColdFusion to do too much - believe
me I know this from experience. ColdFusion should only be used as the glue
to integrate your output. It is not designed to be a workhorse.
What database are you using? You can probably do a lot of the work on the
database side, if you are using a true database server, using triggers and
stored procedures. It sounds to me like you may well be in need of a whole
separate OLAP database. That is where I would suggest that you direct your
thoughts - it will save you a whole lot of grief, and your server will
continue to be your friend.
Patrick Harkins
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: September 20, 2001 6:46 AM
To: CF-Talk
Subject: I'm resending - help
Resending this, please take a look (haven't got response).
I have a complexed CFM template that output a result page after a long
process.The process includes: connecting to 3-4 diffrent datasources, string
manipulation, math calculations, links, includes, everything...
I though about the following way to cache: Every cfoutput (and other html/js
code) is
store incremently in a cf variable. (upon succesful completion of every
phase).
In the end, I output the result to the user and store that variable in a SQL
table with a UID. Then, the second time a user calls the CFM, I first check
if the output
content is already in SQL, and output it. If the content is not there, or
expired, I simply parse the
CFM from the start.
Any comments on my way to do this?
What is better in this way, store the output content in SQL or a text file
(and then <cfinclude> it)?
Michael.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
