On 25.08.2006, at 1:15 Uhr, Marcos Trejo Munguia wrote:
I have a doubt related to object caching, suppose you have the next
relationship A<->>B, if you fetch objects of A, then objects of B,
it isn't supposed that when you access objects of B through objects
of A this objects of B are already cached in memory and there's no
need to do a trip to the db to bring them? Because I,m debugging
the SQL that EOF generates and this is not happening, another query
is performed to bring those objects B related to object A. It isn't
enough to fetch the objects that you need to get them cached in
memory?
You should set up relationship pre-fetching either in the model or in
the fetch specification for object A.
