Prev: Arbitrary-precision arithmetic in ColdFusion?
Next: paypal cfhttp and you
From: Nathan on 21 Jan 2010 23:09
Hello,

I have a complicated CFMX template that runs perfectly untill a larger
date-range is selected. I need to be able to run up to seventeen weeks
worth of data, but I get unresponsive page requests for date
combintations more than three weeks (i.e. week 1 through 3, week 9
through 11, etc. work ok. week 1 through 5 never returns). At first I
thought maybe some of my code was a problem - as listed below. But
other than the page not responding, everything appears to be as
expected: when I run the admin Server Monitor the queries each take
about 35 seconds; the timeout request tags are set in Application.cfm
and set in the template to 4800 seconds (2 hours); the total data
returned is really not that much data - a couple arrays of 1000s of
records each; the total memory usage never goes above about 50 MB; and
the total memory usage does appear to oscilate up and down repeatedly
over one-minute periods of time but does not appear to run-away in
ever-increasing amounts. Can anyone help?


My template goes like this (remember there are no errors or timeout
erros occurring)...
-Begin page...
-Run dyamic query based on report criteria selections...
-Loop through restuls and create a two X one-dimension arrays, and two
X comma-delimited-lists...
....
<cftry>
<cfloop from="1" to="[dynamically determined, about 9 to 27]"
index="idx">
<cfquery name="qry_#idx#"
datasource="my_peoplesoft_oracle_dsn">
SELECT [cols]
FROM [tables]
WHERE [most filters]
AND (
<cfloop from="1" to="[25 or less if the end is
reached]">
[next sql sub_statement from an array
generated earlier in the code]
</cfoop>
)
</cfquery>
<cfoutput query="qry_#idx#">
<cfset st[ArrayLen(st)+1][1] = Evaluate
("qry_#idx#.column1")>
<cfset st[ArrayLen(st)][2] = Evaluate("qry_#idx#.column2")
>
</cfoutput>
</cfloop>
<cfcatch type="any">
<display catch error>
<display catch message>
</cfcatch>
</cftry>
....
<cfloop from="1" to="#ArrayLen(st)#">
...output results...
</cfloop>


Thank You For Your Time,

Nate
 | 
Pages: 1
Prev: Arbitrary-precision arithmetic in ColdFusion?
Next: paypal cfhttp and you