插入语句需要花费太多时间 [英] Insert statement taking too much time

问题描述

嗨朋友们，



我一直面临一个问题，即插入语句需要花费太多时间。我有相同的数据库和代码副本，但本地它需要几秒钟，但是当我在Web服务器上部署代码时，它只需要大约110秒就可以获得5000条记录。



我们只有一个差异是IIS和SQL服务器在不同的服务器上，

我们检查了索引和空间相关的问题，但这些不存在。



请建议如何追踪或解决这个问题。



谢谢

Hi Friends,

I have been facing one issue that is, insert statement taking too much time.I have the same replica copy of database and code but locally it takes fraction of seconds,but when i deploy the code on the web server it is taking around 110 seconds for only 5000 records.

Only one diffrence that we have that is IIS and sql server are on diffrent server,
We have checked the indexing and space related issue but these were not present.

Please suggest how to track out or resolve this issue.

Thanks

推荐答案

检查此帖子

SQL在SSMS中运行得很快，在ASP.NET中运行得很慢 [ ^ ]

这篇关于插入语句需要花费太多时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！