You can recompile it, I believe.
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:22 PM, 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 - > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
