I'm querying the delivery logs (nms:broadLogRcp:profileBroadLog) to get a certain delivery using Label of Delivery is equal to "[label name], and Status = "Sent", and Event date "is within today". It is taking almost a half hour for this query to execute. This seems like an obscene amount of time to search. Is there a faster way to get delivery information about particular labels? What I'm trying to accomplish is to determine recipients whom have received an email, then send a follow-up email, to those whom have not updated information we are storing locally in our onsite DBs requested in the email? Is there a faster way to determine whom has received an email sent, other than querying the delivery logs (nms:broadLogRcp:profileBroadLog)?
Thank you for any help with this,
Querying the broadlog table would be the right way to go.
Half an hour indeed seems very long.
Can you maybe post a screenshot of the query you are using?