Sql Stored Procedure and records in "use"
Posted on 2016-08-25
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?