Hello Ayende, Thank you for your reply! I went to the NHibernate code and disabled the thing that I thought that we call the first level cache: NHibernate.Engine.Query.QueryPlanCache.cs line 72: planCache.Put(key, plan); and commented it, that solves my problem, but what kind of collateral effects can this have?
Thank you, Bruno Ayende Rahien wrote: > You should not load all rows to memeory in one go. Use slices and > commit the transaction between each slice. > This is explicitly spelled out in the search docs. > > On Wed, Sep 17, 2008 at 5:16 PM, Bruno Matos <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > I'm developing a windows service application that saves > information in a Lucene.NET index to make text searches. This > application uses NHibernate to retrieve information from the > database. > > For now there is, at least, one big problem, this is working only > for a specific database, with time I hope I can abstract it for > all given databases. Another problem is the initial memory leak to > generate the index when the database is already full of records. > > I have a entire solution with this, I can put it available, just > need to talk to my boss and have a place for it. > > Regards, > Bruno > > Ayende Rahien wrote: >> This is the place for this. >> And you might want to show some code. >> >> On Wed, Sep 17, 2008 at 2:23 PM, Bruno Matos >> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: >> >> >> I can tell you more Fabio, what I'm doing could help a text >> search for NHibernate as the text searcher for Hibernate. >> >> If some one is working on this, please contact me. We can >> exchange code and ideas. >> >> >> Thank you, >> Bruno >> >> Fabio Maulo wrote: >>> As you want... BTW I'm doing massive import from XML and >>> text files without have your problem and without use evict >>> or clear. >>> >>> 2008/9/16 Bruno Matos <[EMAIL PROTECTED] >>> <mailto:[EMAIL PROTECTED]>> >>> >>> Hi Fabio, >>> >>> I sow that and I did the evict of every object and then >>> a session.clear() - just didn't work. I sow either the >>> next paragraph, maybe the ORM is not yet ready for that >>> mass execution queries, but it should and I'm here to >>> help in what I can! >>> >>> Thank you, >>> Bruno >>> >>> >>> Fabio Maulo wrote: >>>> Bruno... >>>> If you have NHibernate in Action take a look to >>>> paragraph 5.3.2 in particular read this (from book): >>>> Managing the first-level cache >>>> Consider this frequently asked question: "I get an >>>> OutOfMemoryException when I try to load 100,000 >>>> objects and manipulate all of them. How can I do mass >>>> updates with NHibernate?" >>>> >>>> Bye. >>>> Fabio Maulo >>>> >>>> 2008/9/16 Bruno Matos <[EMAIL PROTECTED] >>>> <mailto:[EMAIL PROTECTED]>> >>>> >>>> Hi James, >>>> >>>> They told me to study, and was what I did. :) >>>> But the simple Hello World of the "NHibernate in >>>> Action" has the same problem, just insert 100,000 >>>> rows in the Employee table and the programs >>>> consumes 60MB, that never releases, even with the >>>> forced GC. >>>> >>>> Thank you, >>>> Bruno >>>> >>>> >>>> >>> >>> >>> >>> >>> >>> >>> -- >>> Fabio Maulo >>> >>> >> >> >> >> >> >> > > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
