On Dec 5, 2004, at 21:48, Andrus Adamchik wrote:
> So you are suggesting to cache snapshots from this join table... It
> maybe a good idea - we are filling the gaps in the information
> available to Cayenne runtime, so that we can do smarter matching of
> object and DB layers in memory. But here is my concerns... First we
> will need a new type of key (DataRowId?), second we will have to do
> in-memory DbRelationship traversal of snapshots. This bothers me as it
> will turn Cayenne itself into an in-memory relational database. This
> was never the idea.
I agree. I was thinking about a generic shared to-many cache, but the
join solution looks easier and cleaner.
> Here is my idea how to fix CAY-15. It is based on implementing support
> for single-query prefetching using joins (in addition to the current
> prefetching mechanism that uses a separate query for each prefetch).
....
> Actually this may even turn out to be simpler than creating a new
> mechanism for caching data rows. What do you think?
That looks like a very nice solution! It should be a boost for
applications that does not use flattened many-to-many as well.
- Tore.
This archive was generated by hypermail 2.0.0 : Sun Dec 05 2004 - 16:20:25 EST