cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
Subject Re: problem with ROP query performance
Date Wed, 26 Oct 2011 19:22:36 GMT
Yeah sounds odd. It fetches paintings of that artist. Maybe we can jira that and take a closer

On a side note, I noticed that due to the weak references used in the DataContext to store
committed objects, you may see lots of faulting of objects that were fetched in the same context
just a few seconds ago. This is probably completely unrelated, and for that we are experimenting
with using soft references (instead of weak) via a new ObjectMapRetainStrategy (available
in 3.1M3).


On Oct 21, 2011, at 9:22 AM, Marcin Skladaniec wrote:

> Hi
> There is a discrepancy in behaviour of performQuery between ROP and non-ROP setup.
> lets consider this simple code:
>        DataContext newContext = ...
>        Artist artist = newContext.newObject(Artist.class);
>        newContext.commitChanges();
>        Painting painting = newContext.newObject(Painting.class);
>        painting.setArtist(artist);
>        assertEquals(artist.getPersistenceState(), PersistenceState.MODIFIED); // this
is true
>        SelectQuery sq = new SelectQuery(Painting.class, ExpressionFactory.matchExp(Painting.ARTIST_PROPERTY,
>        newContext.performQuery(sq);
> I have added some logging to the performQuery() to check what happens. This is what I
see in ROP setup:
> DEBUG - select query for Painting with qualifier: artist = <ObjectId:Artist, id=200>
> DEBUG - RelationshipQuery:paintings for: <ObjectId:Artist, id=200>
> Seems straightforward, select query is executed... but then cayenne faults the Artist
object and its relationships. This would be ok, but the Artist object is already in the context,
no trip to the databse required!
> Same code in non-ROP setup does not behave teh same - the RelatioshipQuery is not executed
(unless artist.getPaintings() is called explicitly).
> For us this Relationship Query is a big big performance problem.
> Is that a bug in ROP? Is there a way to prevent faulting of the relatioship?
> With regards
> Marcin

View raw message