I will post about my results using the domain of this test http://fabiomaulo.blogspot.com/2009/08/nhibernate-perfomance-analisys.html <http://fabiomaulo.blogspot.com/2009/08/nhibernate-perfomance-analisys.html>this time using more than 100K entities. Btw if you need to load 100K you should use something else, NHibernate is not the tool you are looking for.
2009/9/3 Ricardo Pedro <[email protected]> > > 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 - > > > -- 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 -~----------~----~----~----~------~----~------~--~---
