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]> 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]>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]> >> >>> 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]> >>> >>>> 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 -~----------~----~----~----~------~----~------~--~---
