Hi Fabio, Thank you very much for your answer. I can add some more information about this...
The big diference between NH and EF are in the "materialize" or "hidrate" time! I don't have the solution for this, but I can add more information to try solving it... I run the jetBrains dot Trace, and what I found was the Hidrate method to conusme almost all the time. And this is where the transformation of the SQL result to POCO is made. This is where the bottleneck is. I have also tried to use a Stateless Session and the result was even worse. I'm getting 60000 rows from the DB and with Session is taking 11000 ms and with stateless is taking 29000ms Ricardo On 3 Set, 14:31, Fabio Maulo <[email protected]> wrote: > Or > thishttp://fabiomaulo.blogspot.com/2009/08/nhibernate-perfomance-analisys... > > <http://fabiomaulo.blogspot.com/2009/08/nhibernate-perfomance-analisys...>but > Humberto... is NH the right tool to upload 100K entities > ?http://fabiomaulo.blogspot.com/2009/09/data-mining-in-5-minutes.html > > 2009/9/3 Humberto Marchezi <[email protected]> > > > > > > > Hi Ricardo, > > > Search for stateless session in NHibernate. > > > Also, read this: > > >http://ayende.com/Blog/archive/2009/08/15/benchmarks-are-useless-yes-... > > > sds > > > On Wed, Sep 2, 2009 at 10:17 AM, Ricardo Pedro <[email protected]>wrote: > > >> Hi to everyone. > > >> I'm an user of NH and I'm using it in lot's of personal and > >> profissional projects. > > >> This week I found a performance issue on NH that is killing me. > > >> I need to materialize 100.000 objects and NH is taking around 6000 ms > >> to do that. I think that is too much time and I run the dotTrace > >> Profiler to sse where is the bottleneck. I found that it is in a > >> method Hydrate. > > >> I also found a web sitehttp://www.ormbattle.net/where they compare > >> several aspectos of NHibernate to Entity Framework. > > >> I found that this aspect of materialize/hydrate objects are a problem > >> in NH. > > >> What do you think about this. If EF can materialize faster can't NH do > >> that too ? > > >> Ricardo > > > -- > > Humberto C Marchezi > > --------------------------------------------------------- > > Master in Electrical Engineering - Automation > > Software Consultant and Developer > > at the Town Hall of Vitória > > -- > Fabio Maulo- Ocultar texto citado - > > - Mostrar texto citado - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
