这个有performane区别吗？# DotNet - 窗口里的风景
d*g
1 楼
我在.net的一个event里call几个stored procedures和call一个，在数据库那边call几
个procedures.这个在速度上有区别吗？
thanks
个procedures.这个在速度上有区别吗？
thanks
s*o
2 楼
It depends.
Usually a single trip to the database is better than several visits, but
sometimes retrieving data with several different queries actually performs
better than using a single query with complex joins.
If performance is really important in this case, you can run some benchmarks
to measure the difference.
Usually a single trip to the database is better than several visits, but
sometimes retrieving data with several different queries actually performs
better than using a single query with complex joins.
If performance is really important in this case, you can run some benchmarks
to measure the difference.
d*g
3 楼
多谢，请问有什么benchmark online sample可以参考吗？
s*o
4 楼
You could just use a timer in your code.
【在 d****g 的大作中提到】
: 多谢，请问有什么benchmark online sample可以参考吗？
【在 d****g 的大作中提到】
: 多谢，请问有什么benchmark online sample可以参考吗？
p*r
5 楼
通常server自己call更快，
但是你可以做个loop，分别测试一下。
但是你可以做个loop，分别测试一下。
vn
6 楼
感觉区别不会太大 现在call数据库缓存据说很完善了
call一次可能time out
call一次可能time out
相关阅读
Any ASP.NET forum in China? Free Beta1Which one do u use? ms provider vs. odp.net?是IISRe: 哪里了可以弄到ISS哪里了可以弄到ISS[转载] C# 中comboBox DataBinding 问题how to add icon to menu item.是否可以通过Java的程序直接导入网页？xmldocument and webservice questionNested Datalist layout!!drag and drop请教高人！Re: [转载] 怎么建一个基本网站where to download .net 1.1 fix?how come this board is so......leng qing?问个VS.NET初级问题Help!!Visual C++ .net questionTabControl一问Dot net hosting