提高sqlserver中的查询性能 [英] Increase Query performance in sqlserver
问题描述
亲爱的，请帮助我。
我遇到了严重的问题。我的要求是提高sqlserver中查询的性能。
现在我在交易表中工作。发生以下步骤
1.我的查询从表中检索4000个手机号码（使用东西）然后将这些手机号码发送到另一个网关发送短信。
2.从网关接收响应，将其插入另一个包含手机号码详细信息的表格。
3.删除交易表中的记录基于手机号码。
此过程继续。
工作正常当记录的数量较少（少于10万）时。但是当表有20-25万条记录时，问题就出现了。选择4000条记录需要3-4分钟。当时正在插入其他记录。所以如何解决这个问题。
Dear All,Please help me.
I am in a serious issue.My requirement is to increase the performance of the query in sqlserver.
Now i am working in a transaction table.The following steps occurs
1. my query retrieves 4000 mobile numbers from the table (using stuff) and then send these mobile numbers into another gateway for sending sms.
2. Receive the response from the gateway, Insert it into another table with mobile numbers details.
3. Delete the records from the transaction table based on the mobile numbers.
This process continues.
It works fine when there is less number of records(less than 10 lakh).But when the table has 20-25 lakhs of records then the problem arises.Selecting the 4000 records takes 3-4 minutes.Within that time other records are inserting.So How to solve that problem.
推荐答案
从这里开始： http://msdn.microsoft.com/en-us/library/ff650692.aspx [ ^ ]
http://msdn.microsoft.com/en-us/library/ff650699.aspx [ ^ ]
Start here : http://msdn.microsoft.com/en-us/library/ff650692.aspx[^]
http://msdn.microsoft.com/en-us/library/ff650699.aspx[^]
检查这个答案，我已经解释了许多主题的内容以改进。
如何提高网站性能？ [ ^ ]
检查数据库优化为您的问题。
Check this answer, I have explained things on many topic to improve things.
How to improve performance of a website?[^]
Check Database optimization for your issue.
这篇关于提高sqlserver中的查询性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
