Re: OutOfMemoryErrors (solved)

From: Frank (farocc..otmail.com)
Date: Thu Feb 15 2007 - 09:45:19 EST

  • Next message: Frank: "Re: How to query a relationship"

    My query returned less than 2700 records.
    My schema was large, about 190 fields.

    I trimmed this down to about 5 and increased the JVM.

    Regards,

    Frank
    ----- Original Message -----
    From: "Michael Gentry" <blacknex..mail.com>
    To: <use..ayenne.apache.org>
    Sent: Thursday, February 15, 2007 9:27 AM
    Subject: Re: OutOfMemoryErrors (solved)

    > Bumping the heap size up is probably fine, but I also suspect Frank
    > might be trying to read in too much data given his previous postings
    > using LIKE expressions. He may be getting back tens of thousands of
    > rows, if not more. Perhaps his application requires that, though.
    >
    > /dev/mrg
    >
    >
    > On 2/15/07, Andrus Adamchik <andru..bjectstyle.org> wrote:
    >> You are being too picky. Why is this not a solution? Default 64m heap
    >> size for the JVM is not enough for most applications nowadays ;-)
    >>
    >> Andrus
    >>
    >>
    >> On Feb 15, 2007, at 2:47 AM, Juergen Saar wrote:
    >>
    >> > This is a workaround, but not a solution ...
    >> >
    >> > -sorry-
    >> > --- Juregen ---
    >> >
    >> > 2007/2/14, Frank <farocc..otmail.com>:
    >> >>
    >> >> Hi Andrus,
    >> >>
    >> >> I bumped the JVM up to 512m
    >> >> This resolved my issue.
    >> >> I also removed AS400 fields not needed in my query to help reduce
    >> >> memory
    >> >> requirements.
    >> >>
    >> >> Regards,
    >> >>
    >> >> Frank
    >> >>
    >> >>
    >>
    >>
    >



    This archive was generated by hypermail 2.0.0 : Thu Feb 15 2007 - 09:46:04 EST