Re: Memory usage and select statements

From: Mike Kienenberger (
Date: Mon Jun 30 2008 - 11:07:41 EDT

  • Next message: Michael Gentry: "Re: Loading small tables into memory for the application lifetime"

    On Mon, Jun 30, 2008 at 5:30 AM, Řyvind Harboe <> wrote:
    > On Mon, Jun 30, 2008 at 11:01 AM, Andrus Adamchik
    > <> wrote:
    >> There is no lazy fetching of attributes (only relationships). We will be
    >> adding it at some point. It is a bit more involved than simply suppressing a
    >> given column in the SQL translator. Still you have a few of options:
    >> 1. Place large columns in a separate table with 1..1 relationship to the
    >> master table .
    > Hmm... will this actually work?

    Yes, a separate dependent table is how I've been dong it. I hadn't
    realized that #2 with a second entity to the same table was an option.
      I'll have to keep this in mind for future work. Thanks!

    > 2. Do not map large columns in the ObjEntity and resolve them manually on
    > demand (either with SQLTemplate, or by mapping a second entity to the same
    > table).

    This archive was generated by hypermail 2.0.0 : Mon Jun 30 2008 - 11:08:12 EDT