db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Artur Z" <arte...@o2.pl>
Subject doSelect with collections filled
Date Thu, 02 Sep 2004 07:53:41 GMT
hello

please help - I have a performance problem
there are two tables: Book and Author
I call AuthorPeer.doSelect(new Criteria()); - it returns all authors
now i want to print all authors and their books
on each author I must call author.getBooks();
every time I call this method a database is queried for books for this
author
and when there are 2000 authors, there will be 2000 calls to database, which
of course takes much time

the question is:
how to query author table to get in return list of authors with already
initialized books collections

thanks a lot

Artur



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message