Hi, I'm struggling with a performance problem and would like create a query instead of working collections. I'm not very experienced with queries and don't know which query technique to choose how to forumlate the query(only some blogs where warned to use hql in performance critical invironment). First: what query technique is best for performance critical issues Second my query problem: I can narrow it down to two entities which can simplified like that: Order (columns: Id, OrderType) OrderItems (columns: Id, OrderId, OrderItemType)
I do know the OrderType and OrderItemType and like to get all orders of the given OrderType which have at least one OrderItem of the given OrderItemType. Do you have any help for me how to solve that most efficiently. Thank you so much for your help and effort antoschka --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
