Re: Relationships across databases

From: Øyvind Harboe (oyvind.harbo..ylin.com)
Date: Wed Jun 20 2007 - 17:17:25 EDT

  • Next message: Juergen Saar: "Re: Relationships across databases"

    On 6/20/07, Mike Kienenberger <mkienen..mail.com> wrote:
    > If I recall, it means that for a given query select ID from table1 t1,
    > table2 t2 where t1.id = t2.id, you will have to do something like
    > this:
    >
    > List list = select T1_ID from table1;
    > for each item in list
    > {
    > select * from Table2 where t2.id = item.t1_id
    > }
    >
    > The multiplication is number of the queries issued, not the memory used.
    >
    > Obviously, the simple case above could be optimized using an IN
    > statement, but anything that wasn't trivial could not be.

    How can the application do this more efficiently than Cayenne could?

    Cayenne can only said to be inefficient if the application could,
    somehow, do this more efficiently, right?

    -- 
    Øyvind Harboe
    http://www.zylin.com - eCos ARM & FPGA  developer kit
    



    This archive was generated by hypermail 2.0.0 : Wed Jun 20 2007 - 17:17:51 EDT