fix which has been mentioned...its more than likely due to the way that JRun
uses around 3 to 4 times as much memory than CF5 and with large record sets
it cannot release memory quick enough and in the end - it crashes. It
normally only happens with a Stored Procudure and when the result set has a
load of text datatypes in it.
Here is the technote on the subject (unfortunately the solution is to bring
back your data in smaller chunks ...which is quite simply bollox)
http://www.macromedia.com/support/coldfusion/ts/documents/large_record_sets_
oom.htm
________________________________________
From: Jim Voris [mailto:[EMAIL PROTECTED]
Sent: 05 August 2004 22:35
To: CF-Talk
Subject: JRun Process Hangs on Queries with Large Number of Columns
In my application a query is executed via cfstoredproc.��This is an
"ad hoc" query, where the user may select a number of columns.��It
works as designed, except when a large number of columns are
selected...say 85 or so.
The actual queries which cause the hang, execute just fine in query
analyzer.��
The I/O is not that big...maybe 32K or so.
When the query succeeds, JRun spikes for a second or two at 99% the
immediately drops off.��When it hangs JRun pegs at 99%.
Any thoughts?
Thanks in advance.
________________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
