Export sent SMSs

Avatar

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
Bruno_Cotrim
Level 2

13-03-2019

Good Morning,


I've implemented some workflows to be able to save the text value of sent SMSs, it works but I've a issue with it that I hope someone call help me with.

To compute the value of the SMS text I'm building a preview of the event history, using the method "BuildPreviewFromId", this works for both messages sent via message center and via regular delivery, the thing is the same method has an enormous difference in performance when called internally or called via SOAP Service (for message center), strangely it is much faster when called via SOAP.

The method takes 20 - 120s to calculate 2500 messages via SOAP call and takes 1.1 - 3s to calculate one single message when called internally, it should be noted that the 120s include a remote query and connections so you could actually slash that time by half for the method.

Remote Call:

remote call.JPG

Internal Call:

Internall call.JPG

Can someone point me to a reason or solution for this?

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

18-03-2019

Should be same. Do you have access to trace sql calls on the db server (or from app server via nlserver tracefilter)?

Avatar

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
Bruno_Cotrim
Level 2

19-03-2019

@wodnicki We've a hosted environment so I don't think I've access to those logs.