NOLOCK的替代解决方案 [英] Alternative solution of NOLOCK

问题描述

您好CodeProject，



我们在申请中遇到问题;在许多程序中，SELECT Query是在没有NOLOCKS的情况下编写的，这会产生太多的PERFORMANCE问题。



请建议一些替代方案，以便我们可以去AHEAD来提高性能申请（除外指数）;不要在每个程序中改变并用SELECT NOLOCK语句替换所有SELECT。



谢谢，

Nitish Srivastava



SHOUTING删除 - OriginalGriff [/ edit]

解决方案

从您的问题我只能知道您的查询有一些性能问题。您可以优化查询以提高网站的效果。



根据我的知识，如果同时有频繁插入，更新和删除操作，NOLOCK将仅用于表格数据表。



如果您的数据库表没有经常插入，更新或删除操作，那么您不需要使用 NOLOCK 概念你的数据库查询。你唯一需要注意的是你的查询应该优化并花更少的时间来执行。



谢谢

Sisir Patro

Hi CodeProject,

We are facing an issue in our application ; that in many procedures SELECT Query is written without NOLOCKS which is creating too much problem of PERFORMANCE.

Please suggest some alternative so that we can go AHEAD for improving the Performance of Application (EXCEPT INDEXING) ; without going for altering in each procedure and replacing all SELECT with SELECT NOLOCK statement.

Thanks,
Nitish Srivastava

[edit]SHOUTING removed - OriginalGriff[/edit]

解决方案

Hi,

From your question I can only figureout that your query is having some performance issues. You can optimize the query for increasing your performance of website.

As per my knowledge NOLOCK will only be used on a table if there is a frequent insert, update and delete operation simultaneously on the same table of data.

If your database tables are not having frequent insert, update or delete operations then you need not to use NOLOCK concept in your database query. The only thing you need to pay attention is your query should be optimized and take less time to execute.

Thanks
Sisir Patro

这篇关于NOLOCK的替代解决方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！