I am running some more tests and puttint a "using" statement around
the session made a huge difference as well.
using (ISession session = CurrentSession)
{
......
}
On May 28, 7:22 am, Waqar Sadiq <[email protected]> wrote:
> I will try Tuna's suggestion. Unfortunately, we are limited to the
> NHibernate version that is supported by Spring.Net GA version :-(
>
> On May 28, 7:16 am, Eric Kepes <[email protected]> wrote:
>
>
>
> > And the query plan cache keeps growing in 2.0.1. We ran into this problem,
> > as described by RasmusKL here
> > (http://www.rasmuskl.dk/post/A-WinDbg-Debugging-Journey-NHibernate-Mem...).
> > We couldn't move to a newer version yet, so in the meantime my hack was to
> > recycle the session factory every hour, which seems to have resolved the
> > issue, but of course the better solution is to get a newer version of
> > NHibernate.
>
> > On Thu, May 28, 2009 at 8:13 AM, Tuna Toksoz <[email protected]> wrote:
> > > string queryStr = string.Format("from Member m,
> > > VirtualCard v where v.IpCode = m.IpCode and v.LoyaltyIdNumber =
> > > '{0}'", loyaltyIDNumber);
>
> > > If you use this like this, you'll have different cached query execution
> > > plans for different ids. Try using parameters instead
>
> > > v.LoyaltyIdNumber=:loyaltyIdNumber
>
> > > and
>
> > > .SetParameter("loyaltyIdNumber",33)
>
> > > This might be one reason.
>
> > > Tuna Toksöz
> > > Eternal sunshine of the open source mind.
>
> > >http://devlicio.us/blogs/tuna_toksoz
> > >http://tunatoksoz.com
> > >http://twitter.com/tehlike
>
> > > On Thu, May 28, 2009 at 3:10 PM, Waqar Sadiq <[email protected]>wrote:
>
> > >> string queryStr = string.Format("from Member m,
> > >> VirtualCard v where v.IpCode = m.IpCode and v.LoyaltyIdNumber =
> > >> '{0}'", loyaltyIDNumber);- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
