Hi Sean, Thanks for the reply. To put it in perspective, the same code/data works fine on a machine with only 512M of RAM when running CF 4.5. I have tried setting the MaxPermSize and the overall Heap as high as they can go (512/1024MB respectively) to no avail. When I try setting these any higher CF does not even start (although I have only 2G RAM on the machine). Does MX really need that much more overhead the 4.5 and 5?
Cheers, Leon > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Sean A Corfield > Sent: Monday, 15 March 2004 3:35 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Long Queries / java.lang.OutOfMemoryError > > On Mar 14, 2004, at 8:27 PM, Leon Seremelis wrote: > > 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 > > --- 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
