Re: OutOfMemoryErrors (solved)

From: Michael Gentry (blacknex..mail.com)
Date: Thu Feb 15 2007 - 09:49:37 EST

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

    That's still a lot of records to return from a query, but sometimes
    you need that, too. Increasing the memory is probably appropriate,
    then.

    /dev/mrg

    On 2/15/07, Frank <farocc..otmail.com> wrote:
    > 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:50:07 EST