Click here to Skip to main content
15,944,397 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
[no name] 19-Apr-14 16:29pm    
Profile it.

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.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900