we are sending almost million email. our process runs in cfthread. MSSQL gives recordset, when we loop through emails, we are updating records as sent.
when we run email sending process every one minute it works fine, when we run every 30 seconds. it start feeding records multiple times.
although we flag records when we pull as pulled but still facing issues. It look like when 1st request is in process, 2nd request comes before updating as pulled flag it serves again same record.
i don't want to lock the table because while, im pulling records, im sending emails and updating records as sent in same table.
please advice me.
Aucun commentaire:
Enregistrer un commentaire