忽略mssql server中的延迟响应时间 [英] Ignore late response time in mssql server

问题描述

如何忽略sql对重数据的延迟响应



我尝试过：



我试图在服务器中执行查询，响应完整数据需要50秒到1分钟的时间。

How to ignore late response in sql on heavy data

What I have tried:

I have tried to execute the query in server, it takes 50 seconds to 1 minute time to response the full data.

推荐答案

尝试删除 CONVERT 。在表示层中进行转换。



使用 IsActive 做类似的事情也可能有所帮助。



另外，尽量避免对列名或表名使用保留字。如果你必须使用它们，然后用方括号包围它们。

Try removing the CONVERT. Do that conversion in your presentation layer.

Doing something similar with IsActive will probably help too.

As an aside, try to avoid using reserved words for column or table names. If you must use them then surround them with square brackets.

select ID, ErrorDescription, ErrorPage, IpAddress, 
 PageEvent, [Status], CreatedDate,
 [Status] as IsActive from dbo.ExceptionLog order by ID desc

检查此表上是否有任何索引 - 至少在ID上。

Check to see if there are any indexes on this table - on ID at the very least.

这篇关于忽略mssql server中的延迟响应时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！