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
|