这个有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
相关阅读
请问想考mcsd,是选vb.net还是c#呢?CVS +.NETMS SQL Report Server Questionshow to use old DLL in VB .NET?[转载] 如何知道CLIENT一端屏幕的大小？有没有好心人....NET 界面控件那位VB.NET 的大侠帮个忙。哪位大虾知道caller ID 如何编写？difference between property and indexer 有没有人在LONGHORN测试版上试过装VS2005BETA?Crystal Report 9 languageHow to kill popup in Outlook add-ins?memory leakcross browser/platform .net!?How to define a explict type cast func请问大家有什么便宜的HOSTING SERVICE推荐?about visual studio.net upgrade请教NANT的一个问题[转载] SQL Standard