SQL Server插入、更新、选择的最快方法

I use SPs and this isn't an SP vs code-behind "Build your SQL command" question. I'm looking for a high-throughput method for a backend app that handles many small transactions. I use SQLDataReader for most of the returns since forward only works in most cases for me.I use SPs and this isn't an SP vs code-behind "