Hi Björn,
[EMAIL PROTECTED] wrote:
hi there,
assuming we need multiple lists of objects from the db.
which of the following solutions do perform better?
1)
1 db call using the ojb collection descriptor with retrieve = true
(multiple joins)
i heard about performance issues with too many joins ...
2)
multiple db calls in 1 transaction retrieving each of the lists
separately with broker.getCollectionByQuery calls
Sorry, I don't see your point, could please describe more detailed.
Do you mean 'auto-retrieve=true' for collection-descriptor in 1)?.
If these queries will be performed often, I would recommend to write a
performance test to compare both possibilities.
regards,
Armin
with best regards,
Björn
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
