为什么 NHibernate 生成的参数化 SQL 和存储过程一样快? [英] Why is parameterized SQL generated by NHibernate just as fast as a stored procedure?

问题描述

我的一位同事声称，即使执行路径被缓存，从 ORM 生成的参数化 SQL 也没有任何方法像存储过程一样快.对这个顽固的开发者有什么帮助吗?

One of my co-workers claims that even though the execution path is cached, there is no way parameterized SQL generated from an ORM is as quick as a stored procedure. Any help with this stubborn developer?

推荐答案

我会先阅读这篇文章:

http://decipherinfosys.wordpress.com/2007/03/27/using-stored-procedures-vs-dynamic-sql-generated-by-orm/

这是两者之间的速度测试:

Here is a speed test between the two:

http://www.blackwasp.co.uk/SpeedTestSqlSproc.aspx

这篇关于为什么 NHibernate 生成的参数化 SQL 和存储过程一样快?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！