Re: performance question

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]
> 
>