Delivery Logs Query Time

Avatar

Avatar
Validate 1
Level 1
JohnnyBravo
Level 1

Likes

0 likes

Total Posts

19 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
JohnnyBravo
Level 1

Likes

0 likes

Total Posts

19 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
JohnnyBravo
Level 1

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 (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

271 likes

Total Posts

397 posts

Correct reply

199 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

271 likes

Total Posts

397 posts

Correct reply

199 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
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?

Answers (2)

Answers (2)

Avatar

Avatar
Affirm 100
MVP
shelly-goel
MVP

Likes

249 likes

Total Posts

410 posts

Correct reply

107 solutions
Top badges earned
Affirm 100
Give Back 25
Ignite 3
Give Back 10
Validate 1
View profile

Avatar
Affirm 100
MVP
shelly-goel
MVP

Likes

249 likes

Total Posts

410 posts

Correct reply

107 solutions
Top badges earned
Affirm 100
Give Back 25
Ignite 3
Give Back 10
Validate 1
View profile
shelly-goel
MVP

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?

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

170 likes

Total Posts

931 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

170 likes

Total Posts

931 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

01-12-2020

hi @JohnnyBravo,

Were you able to resolve this query with the given solution or do you need more help? Do let us know.

Thanks!