Ayende @ Rahienhttp://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Dmitry commented on Poor man’s guide to database optimization - by the Marquis de Sade@Sosh, NHibernate is by far the easiest ORM to implement logging. For unit testing you just add the configuration property <property name="show_sql">true</property> into the Web.Config/App.config file. If you want to configure log4net to log into event log, DB, etc, here is the link: [nhforge.org/.../...et-for-use-with-nhibernate.aspx](http://nhforge.org/wikis/howtonh/configure-log4net-for-use-with-nhibernate.aspx) Entity Framework was a different story. It required a provider wrapper that sits between the object context and the database provider. http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment6http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment6Thu, 18 Jun 2009 19:28:51 GMTSosh commented on Poor man’s guide to database optimization - by the Marquis de Sade@Dmitry, Could you give a quick example of how you would do that with say NHibernate? Thanks http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment5http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment5Thu, 18 Jun 2009 12:28:57 GMTChris Missal commented on Poor man’s guide to database optimization - by the Marquis de SadeThis is a really good idea, but why stop there, maybe we can speed it up by using: "waitfor delay '-0:0:0.5'" What do you think?? ;) http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment4http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment4Sat, 30 May 2009 06:27:43 GMTDmitry commented on Poor man’s guide to database optimization - by the Marquis de SadeI always output (and inspect) queries into the console/debug stream for database tests. It's fairly easy to do with any ORM that implements a unit-of-work pattern and with log4net. http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment3http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment3Sat, 30 May 2009 00:18:54 GMTNeil commented on Poor man’s guide to database optimization - by the Marquis de SadeI always thought that each db call should make the workstation beep, or make a systray thingee blink. I never got around to implementing anything like that, though. http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment2http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment2Fri, 29 May 2009 20:50:58 GMTMarkus Zywitza commented on Poor man’s guide to database optimization - by the Marquis de SadeJust an idea: Wouldn't such a thing be a good idea to simulate load on the DB server? http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment1http://ayende.com/4039/poor-man-s-guide-to-database-optimization-by-the-marquis-de-sade#comment1Fri, 29 May 2009 20:36:25 GMT