I probably should add that orderItem has 6000 entities and Order 1200 entities I came up with a hql query select o from Order as o, OrderItem as i join i.OrderId as joinView where joinView.OrderType.Id = 'new' and joinView.OrderType.Id = 'bundle'
Is there something wrong or a better way to do it? Thanks antoschka On 12 Feb., 23:17, antoschka <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
