http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660"There are a few books that I can think of that caused a fundamental change in the way that I am writing and designing software." Can you list a few? http://ayende.com/2931/release-it#comment6http://ayende.com/2931/release-it#comment6Sun, 04 Nov 2007 07:38:02 GMTSteve, you have to look at the bigger picture - column level optimistic concurrency is much easier to do with dynamic sql than with stored procedures and can give much higher throughput than rowlevel optimistic concurrency (or even just transactions). /Mats http://ayende.com/2931/release-it#comment5http://ayende.com/2931/release-it#comment5Sun, 04 Nov 2007 05:52:41 GMTSteve, ORM generate very predictable SQL, with very predictable columns and acess paths. It make it very easy to get the indexes right. http://ayende.com/2931/release-it#comment4http://ayende.com/2931/release-it#comment4Sun, 04 Nov 2007 04:35:04 GMTThis book's mention of the Fail Fast pattern lead me to implement my own FailFast component. It's turned out to be one of the most useful books I've read in awhile. http://ayende.com/2931/release-it#comment2http://ayende.com/2931/release-it#comment2Sun, 04 Nov 2007 00:29:17 GMTThis book's mention of the Fail Fast pattern lead me to implement my own FailFast component. It's turned out to be one of the most useful books I've read in awhile. http://ayende.com/2931/release-it#comment3http://ayende.com/2931/release-it#comment3Sun, 04 Nov 2007 00:29:17 GMT"Section 9.7 talks about the dangers of bypassing the OR/M layer for direct DB access because they can kill the site capacity, I wholly approve. The SQL that most OR/M tools generate is predictable, so it is very easy to optimize for that. Another important thing is that you need to develop against realistic data set. This usually mean building a data generator to spit some data at the DB" I'm still struggling to believe that dynamically generated SQL (ie. from an ORM) performs better than using stored procedures. I think I'll need to see some serious benchmarks to believe it. http://ayende.com/2931/release-it#comment1http://ayende.com/2931/release-it#comment1Sun, 04 Nov 2007 00:11:09 GMT