Hi Jan,
> >why don't you use lazy loading?
> I am using lazy loading !!!
>
>When using lazy loading castor still loads ID's of related objects into an
internal collection. When you iterate over this >
>collection objects are fetched on demand (this touches on shortcomings of
depends tag, but thats a different store). The querry >that retreives object
and related object ID's is the one causing the problem.
Ah, okay, now I got your problem. Castor is creating large SQL queries doing
a join over all related tables to retrieve the Ids. For one collection this
"might" be faster then doing two queries, but for everything beyond it's a
bad idea ;)
Perhaps you could gain a little speed by using OQLQueries instead of
iterating over the resulting lazy collections if you need only specific
objects.
Otherwise refactoring this collection handling part would be definitly an
improvement ...
Regards
Christoph
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
