In the case of option 1, where does the lazy-query get stored? And does the fact that the user could enumerate potentially 'much' later cause any grief?
Sounds easier to issue 1 query with a join to me - but I think I'd vote ultimately for what's simplest/easiest. Sent from my Android phone. On Sep 4, 2009 7:21 PM, "Tuna Toksoz" <[email protected]> wrote: I believe 2nd is a better one, and in my opinion redundant data in this case is not important. another third possibility would be to execute 2 Queries, 1 for orders and 1 for OrderLines and do the shaping on the client. Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Fri, Sep 4, 2009 at 8:41 PM, Steve Strong <[email protected]> wrote: > > > Morning / Aftern...
