是否有一些方法可以降低存储过程的性能 [英] Is there are some ways from which performance of Stored Procedure decreases

问题描述

我正在使用C＃桌面应用程序

我一般使用视图和存储过程从数据库中获取数据

我观察到从视图中获取数据的速度很慢速度与从存储过程中获取数据相比..

是否存在一些存储过程和视图具有相同性能的情况

或者换句话说我可以说有一些方法可以使存储过程的性能降低



请给我你宝贵的建议

提前感谢

解决方案

请参阅此CodeProject文章：存储过程不会提高性能 [ ^ ]。

-SA

经常有问题......



SQL服务器性能：什么是更快，存储过程或视图？ [ ^ ]

TSQL - 查看与存储过程：应用谓词时的性能注意事项 [ ^ ]

视图与存储过程，差异是什么？ [ ^ ]

何时使用视图和存储过程？ [ ^ ]

视图v存储过程 [ ^ ]

I am working in a C# desktop Application
I genrally use views and Stored Procedure for fetching data from database
As i observed that Getting data from a view has slow speed as compared to getting data from stored procedure..
Is there are some cases in which both the stored procedure and view have same performance
or in other word i can say that there are some ways from which performance of stored procedure decreases

please give me your valuable suggestions
thanks in advance

解决方案

Please see this CodeProject article: Stored Procedures DO NOT increase performance[^].

—SA

It's quite often question...

SQL-Server Performance: What is faster, a stored procedure or a view?[^]
TSQL - View vs Stored Procedure: Performance considerations when apply predicates[^]
Views vs Stored Procedures, whats the difference?[^]
When to use view and stored procedures ?[^]
Views v Stored Procedures[^]

这篇关于是否有一些方法可以降低存储过程的性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！