Re: Optimizing object materialization for 1:N relations

2008-02-07 Thread Tino Schöllhorn
Hi Armin, thanks for your reply. Do you think it would be worth a try to materialize our objects with pure SQL - but after initializing them to work with them with OJB? Thanks for your opinion. Regards Tino Armin Waibel schrieb: Hi Tino, Tino Schöllhorn wrote: Hi, we are using

Re: Optimizing object materialization for 1:N relations

2008-02-07 Thread Danilo Tommasina
Hi Tino, I think he meant, that you can load several ACLs with one query and use prefetched relationships for loading all depending ACLEntries for each loaded ACL. Also in this case you will have only 2 Queries, but you will bulk load several ACLs Bye danilo Tino Schöllhorn wrote: Hi

Re: Optimizing object materialization for 1:N relations

2008-02-07 Thread Tino Schöllhorn
Hi, so I will try that. Thanks for your reply. With regards Tino Danilo Tommasina schrieb: Hi Tino, I think he meant, that you can load several ACLs with one query and use prefetched relationships for loading all depending ACLEntries for each loaded ACL. Also in this case you will have