Previously, I mentioned Peter Weissbrod's introduction to performance tuning NHibernate backed applications. Peter worked wonders on a previous project of mine with respect to finding bottlenecks and prescribing appropriate remedies. Peter's back with a second installment of suggestions which may be found at http://www.codeproject.com/useritems/NHibernate_Perf2.asp. This installment includes, among other subjects, a good discussion of transactions, caching and when to leverage stored procedures. (BTW, did you hear that eBay doesn't use transactions?) Anyway, it's a useful read for not only NHibernate users, but for anyone developing against a database.
04-07-2007 6:35 PM