can we do same with out HQL, (//like wise Criteria.CreateAlias,) we are not recommend HQL any where in Product.
On Mon, Sep 13, 2010 at 5:28 PM, Fabio Maulo <[email protected]> wrote: > the clause is : "with" > http://fabiomaulo.blogspot.com/2009/05/nhibernate-210-hql-with-clause.html > > > On Mon, Sep 13, 2010 at 8:23 AM, Armin Landscheidt <[email protected] > > wrote: > >> Hello, >> >> I have a little performance problem and could resolve it if I could >> add the restriction in the where clause to the join clause. Actual the >> generated sql looks like: >> >> select * from parent p >> left outer join child c on c.Parent = p.Id >> where p.Name like '%theName%' or c.Name like '%theName%' >> >> This is to slow. But if I could generate a statement like >> >> select * from parent p >> left outer join child c on c.Parent = p.Id and c.Name like '%theName%' >> where p.Name like '%theName%' >> >> it would be much faster. >> >> Is there a way to realize this? >> >> Regards Armin >> >> -- >> 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]<nhusers%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> >> > > > -- > Fabio Maulo > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- 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.
