NHibernate should run initialization step (build ISessionFactory). it takes 2~4 seconds.
after initialization and session clear, then, running performance checking operation. First time running both DB Query and NHbiernate almost equals. but second times running, NHibernate should be faster than DB Query ( SQL Server make dynamic procedure for you) 2011/7/9 <[email protected]> > Maybe you have a little to much logging enabled or something like that. > > Am schrieb LPatnaik <[email protected]>: > > > I checked the following query using nhProfiler. It takes about 6 ms > > > > for the DB and 3000ms+ for nHiberbate. > > > > > > > > SELECT > > > > ID,RUIN,RUI,RXCUI1N,RXCUI2N,RXAUI1N,RXAUI2N,RXCUI1,RXCUI2,RXAUI1,RXAUI2, > > > > STYPE1,STYPE2 ,REL,RELA,DIR ,SUPPRESS > > > > FROM RXNREL WHERE (RXCUI1N in (369039) or RXAUI1N in (2059926))and > > > > RELA = 'dose_form_of' . > > > > > > > > I am not aware of what may be going wrong. > > > > > > > > The mapping is as below: > > > > > > namespace="TypeModel" > > > > assembly="QAP"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > access="field.camelcase-underscore" /> > > > > > > access="field.camelcase-underscore" /> > > > > > > > > > > > > > > > > > > access="field.camelcase-underscore" /> > > > > > > > > > > > > > > > > > > > > -- > > > > > 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. > > > > > > > > > > -- > 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. > -- 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.
