We help IT Professionals succeed at work.
Get Started
Sql Stored Procedure and records in "use"
I have a VB App that pulls emails from our users subscribed database with a [status] = 0 and sends as an smtp email to a 3rd party api.
As it is successfully sent it updates the sql table [status] = 1
By itself it handles about 12,000 records an hour.
I need to double that ...
I know I can add as separate tasks or even another replica of the same app.
Here is my issue...
If I have one app pulling 10,000 addresses from the SQL Table in my stored procedure
How do I make sure the replica app or second task doesn't pull the same emails into it's own 10,000 addresses recordset?
As it is successfully sent it updates the sql table [status] = 1
By itself it handles about 12,000 records an hour.
I need to double that ...
I know I can add as separate tasks or even another replica of the same app.
Here is my issue...
If I have one app pulling 10,000 addresses from the SQL Table in my stored procedure
How do I make sure the replica app or second task doesn't pull the same emails into it's own 10,000 addresses recordset?
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE