Re: Batching faults?

From: Mike Kienenberger (mkienen..laska.net)
Date: Tue Oct 19 2004 - 10:41:43 EDT

  • Next message: Andrus Adamchik: "Re: Batching faults?"

    "Gentry, Michael" <michael_gentr..anniemae.com> wrote:
    > Does anyone know of a way to tell Cayenne to batch faults into a larger
    > SELECT?
    >
    > I have a higher level object that has many to-one relationships off of
    > it. I can fetch the higher level objects in pretty efficiently at this
    > point, but when I'm presenting the information in a table (web, not DB),
    > all of the single SELECTs for the faults are slowing things down.
    >
    > Basically, I'm looking for a way to Cayenne that when it is time to
    > resolve a Foo ObjEntity fault, to go ahead and do 25 or 50 or 100 of
    > them instead of just one.
    >
    > Thanks!
    >
    > /dev/mrg
    >
    > PS. I can't use a prefetch in this case because I don't have a
    > SelectQuery which brings in the initial top-level objects (long story).

    If the objects aren't related somehow in a query, I can't see what you could
    do to resolve an arbitrary set of them.
    Probably your only hope would be to submit a new query to the database that
    does refetch them.

    -Mike



    This archive was generated by hypermail 2.0.0 : Tue Oct 19 2004 - 10:40:21 EDT