Ricardo,Can you explain which is the real life use-case where you need to upload 100K entities ? Or your intention is only waste time in something you never need ?
2009/9/3 Ricardo Pedro <[email protected]> > > There is a similir discussion here: > > http://groups.google.com/group/nhusers/t/36b822f448c46b8b > > BTW: I'm thrileed that there is now a big discussion and comparison > between NH and EF. > > This should lead to a big improvement in NH, and as an OpenSource big > FAN this is what NH is needing now. > > NH is an excelent ORM so let's put it as the #1 ORM in the market and > as OpenSource. > > Ricardo > > On 3 Set, 14:30, Ricardo Pedro <[email protected]> wrote: > > Hi to all. > > > > 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 > > > > I've put a post in this group, but no answer yet... > > > > Ricardo > > > > On 12 Ago, 21:01, Stefan Nobis <[email protected]> wrote: > > > > > > > > > "F.B. ten Kate" <[email protected]> writes: > > > > > [session vs. stateless session] > > > > > > Well wouldn't NHibernate be slow _every_ time i run this query then? > > > > > Not necessarily. I don't know the exact overhead, but the default, > > > stateful session uses caching mechanisms, so maybe filling the cache > > > is slow. > > > > > I would also suspect, as NHibernate tends to be lazy, that quite some > > > of the internal overhead of initializing everything is delayed until > > > you really do something. > > > > > Another observation I made is that my project which uses NHibernate > > > runs about a order of magnitude slower when run from inside Visual > > > Studio. Directly running the compile exe without VS is much faster > > > (log4net with my logging config and NHibernates intensive logging is > > > my current best candidate for these slowdowns, but I never really > > > investigated this because for me it doesn't matter). > > > > > > After all it has no problems doing so the 2nd time i click the > > > > button. Also afaik EF also has to create these objects. > > > > > Does EF have a session cache (by default)? > > > > > I'd also agree with Fabio that it's quite pointless to micro benchmark > > > a complex beast like a ORM with toy examples, when these tools are > > > usually pay off only in quite complex scenarios and applications. If > > > top querying performance of mass data is your primary goal, never use > > > any kind of ORM, neither NHibernate nor EF. > > > > > > I'm willing to give the stateless session a try though, how would i > > > > implement that? > > > > > Instead of opening a new session with factory.OpenSession() use > > > factory.OpenStatelessSession(). Everything else may be left > > > unchanged. BTW have a look at > > > > >http://www.nhforge.org/doc/nh/en/index.html > > > > > -- > > > Until the next mail..., > > > Stefan. > > > > > application_pgp-signature_part > > > < 1KVerTransferir- 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 -~----------~----~----~----~------~----~------~--~---
