Hi - I have a discussion with some co-workers regarding the number of hits that NHibernate is performing against our database.
Our setup: We are developing ASP.NET applications using NHibernate 2.0 for the data access. We have a web-application containing static information stored in 7 inter-connected classes based on 10 underlying tables. This static information is needed all the time, thus we load all of this into memory when the application starts. Using NHibernate to create and fill this object hierarchy we get 1100 selects being sent to the database. This takes around 6 seconds to complete. My co-workers feel that this is an accident waiting to happed, whereas I myself consider this less of problem - after all we only do this once on application start-up. What do you think? Is 1100 select statements on application start something to be afraid of? Any opinion/advice is appreciated. Regards Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
