• I do agree... understanding the effects of compilation/recompilation on application performance is a worth while investigation. The moral, however, should be "avoid compilation if possible." Speaking anecdotally from experience, I've seen compile times as much as sever hundred milliseconds. 200 milliseconds might no seem like much, but scale it out to 10,000 concurrent users, and you've just tanked you application and caused your phone to ring with the dreaded "the app is slow" call.

    I would argue that if you're turning to recompile as a solution to consistent timings, you need to step back and reconsider the design. You can almost always eliminate the need for a recompile with proper tuning. There are always exceptions, of course, but in your standard OLTP application it's generally not necessary.