Show Blogger Panel Hide Blogger Panel
Alex Yakunin

April 6, 2010

Why forced SQL statement caching isn't always a good option

Dmitri Maximov just sent me a link to an article perfectly explaining why forced statement caching isn't always a good option. "Forced statement caching" (sp_executesql or sp_prepexec) is frequently used in ORM tools as default query execution approach.

The subject of that article is related to DataObjects.Net - it has so-called boolean branchinf feature influencing on produced queries (and thus their cached query plans as well).