Delivery Logs Query Time

Avatar

Avatar

JohnnyBravo

Avatar

JohnnyBravo

JohnnyBravo

09-11-2020

Hi,

 

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,

Johnny Bravo

 

Kind regards,

 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar

ramon_bisswange

Employee

Avatar

ramon_bisswange

Employee

ramon_bisswange
Employee

12-11-2020

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?

Avatar

Avatar

shelly-goel

Avatar

shelly-goel

shelly-goel

21-11-2020

@JohnnyBravoIs this issue resolved for you now? If not, did you try count and preview within query target to see if those results are fetched instantly or not?