Hi, Can you:
1. show me your query (hql, icriteria, queryover or Linq) and the generated query by nhibernate 2. show me the sql that you actually want Met vriendelijke groeten, Danny Van den Wouwer *Software Engineer* *PEOPLEWARE* Duwijckstraat 17 2500 Lier - Belgium +32 3 448.33.38 Facebook <http://www.facebook.com/pages/Peopleware/115011795207742> Twitter <http://twitter.com/#!/PeopleWareBE> www.peopleware.be On Thu, Aug 30, 2018 at 2:58 PM 郭骞 <[email protected]> wrote: > Hi Danny, > I use sql server 2012,for count(1) query will improve a lot because > it just return row_number > > 在 2018年8月28日星期二 UTC+8下午5:04:09，Danny Van den Wouwer写道： >> >> Good database software knows that if you use the aggregate function >> count(*) you don't want to retrieve internally all fields of all the >> involved tables. So count(*) might even be slightly faster then count(1) >> in those cases. It is not a good idea to change this behaviour to count(1). >> Can you tell me which database server you using? >> >> Vriendelijke groeten, >> Van den Wouwer Danny >> >> Software Engineer >> Peopleware NV >> www.peopleware.be >> >> Op di 28 aug. 2018 10:42 schreef Ricardo Peres <[email protected]>: >> >>> Yes, COUNT(1) and COUNT(*) are exactly the same. >>> >>> RP >>> >>> On Monday, August 27, 2018 at 10:08:02 PM UTC+1, Gunnar Liljas wrote: >>>> >>>> It's certainly possible, but I don't understand why it would be an >>>> advantage. >>>> >>>> /G >>>> >>>> Den mån 27 aug. 2018 kl 22:55 skrev Ricardo Peres <[email protected]>: >>>> >>>>> I agree. Why don't you create an issue on >>>>> https://github.com/nhibernate/nhibernate-core? Maybe someone can pick >>>>> it up. >>>>> >>>>> RP >>>>> >>>>> On Monday, August 27, 2018 at 10:56:55 AM UTC+1, 郭骞 wrote: >>>>>> >>>>>> Hi All, >>>>>> is it possiblle for nhibernate query count sql generated not >>>>>> select count(*) but count(1) ? >>>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "nhusers" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> Visit this group at https://groups.google.com/group/nhusers. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "nhusers" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/nhusers. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/nhusers. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
