|
Hi All, I’m having an entity Article
which references another entity ArticleDetail which there is about 2000 of on
each article. Then the same article has
another reference to an entity called ArticleAllocation which for example could
be a few thousand as well. This is an example setup but
we have a similar setup in a project so please don’t critizise the
example although it might appear strange. The problem I get is that
when Castor initializes it makes a query to get the Article-entity and to get
the relations it uses several joins. The result is that in our
real case we get 100.000 rows in the resultset which takes a very long time to
both transfer and convert to real objects. I use lazy-loading so the
creation of the related objects does not take place but it still takes an enormous
time to load. Is there a nice solution to
this (probably general) problem? Regards Mattias Bogeblad _______________________________________________________________
|
