btw this may help you http://fabiomaulo.blogspot.com/2009/08/nhibernate-perfomance-analisys.html
2009/10/27 Fabio Maulo <[email protected]> > StatelessSession or even better executable HQL queries or the best pure > ADO.NET. > When you are working with pure data you should use the best tool to manage > pure data. > > 2009/10/25 R4DIUM <[email protected]> > > >> I have written a webcrawler, which produces a high amount of webgraph- >> nodes consisting of >> 3 attributes: >> >> ID: int >> URI: String >> Collection of references to other nodes >> >> I use NHibernate to store approx. 500 000 of these objects in my MSSql >> database. >> I use a many to many relationship to model the relations. >> >> I do a >> >> ITransaction TX = SX.BeginTransaction(); >> >> here i save all nodes without NHibernate "save-update" in a loop >> >> TX.commit() >> >> The storeage of the nodes is very slow, I wait 30 min until everything >> is stored. >> I wonder if the time I have to wait is normal. How much time, do you >> think, should a sql server need to store the described amount of data >> (Server is on the same system as the Client Tier)? >> >> Any suggestion for solving this problem? >> >> >> >> >> Regards >> >> R4DIUM >> >> >> >> > > > -- > Fabio Maulo > -- 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 -~----------~----~----~----~------~----~------~--~---
