Has anyone had/seen the following problem:
http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm? catid=
143&threadid=493323
That's a pretty old thread (from a year ago, when U3 had just come out).
Been struggling with this one for quite some time now. I'm running MX
6.1 w/hotfixes, MSSQL, IIS6. Tried everything listed in the thread and
like many others had no success. It seems to happen when processing long
queries/stored procedures. The same code will work fine when it is
processing a smaller amount of records.
Well, you are probably running out of Java memory - you say it works fine with a small number of records. You either need to keep increasing the MaxPermSize and / or the overall heap size to reach values that will accommodate your application or rewrite it to return fewer records at a time. Someone on that thread had a query that returned 170 columns and 30,000 records - that's a *big* query and it will take up a lot of memory!
For what it's worth, macromedia.com has the initial heap set to 2Gb and the max heap set to 3Gb. For the most part we run around 1Gb I think but we definitely hit 2Gb during peak traffic and occasionally spike over that.
Expecting to run massive queries in a small amount of memory is rather unrealistic I'm afraid...
Sean A Corfield -- http://www.corfield.org/blog/
"I have always wished that my computer would be as easy to use as my telephone. My wish has come true - I no longer know how to use my telephone."
-- Bjarne Stroustrup
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
