Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Export sent SMSs

Bruno_Cotrim
Level 2
Level 2

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?

2 Replies
wodnicki
Community Advisor
Community Advisor

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

Bruno_Cotrim
Level 2
Level 2

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