"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