Hi. I've solved the problem using reflection to access the planCache field in QueryPlanCache and to set the Hashtable to have a content size from 128 to 8. The Hibernate 4.0 standard does let the planCache field be resizeable, but it doesn't look like the NHibernate standard lets the field be tunable yet.
On Wednesday, December 3, 2014 8:13:58 PM UTC-6, Andrijan Jelovic wrote: > > Hi. Here's my StackOverflow post at > http://stackoverflow.com/questions/27276129/fluent-nhibernate-memory-leak-with-heap-dump-attached > > . > > For a project of mine, I'm creating a folded Expression statement that can > contain on the order of 10000 individual where clauses (so that I can > minimize the number of calls to the database). NHibernate Linq works, but > the large expression trees are being cached in queryPlanCache of the > session factory (which I've verified in Debugging). I need to be able to > clear the queryPlanCache or prevent it from growing. I'm using > IStatelessSessions throughout my code so I can handle large datasets. > > Here's the heap dump using CLRProfiler at > https://app.box.com/s/pvbe9ryfb0v168rka2e3. Is there a way to prevent > the queryPlanCache from being used? > -- 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 http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
