Hello,
Did you defined the foreign key relationship beetwen Author and Book in your schema file?
If yes, there should be protected method in BaseAuthorPeer
doSelectJoinBooks() (or something like that). Write this method as public in AuthorPeer
and than you can use it.
Notice that the join made by Torque when selecting authors and books is inner join
so you won't have the authors who don't have at least a book.
(can be changed i think to left outer join if you patch torque to support outer joins, see mail archive)
Best regards, Andras.
Artur Z wrote:
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
