Looping condition sorting for bulk data in Custom Objects | Community
Skip to main content
New Participant
May 29, 2020
Solved

Looping condition sorting for bulk data in Custom Objects

  • May 29, 2020
  • 2 replies
  • 2415 views

In a loop condition, for each item business need is to sort it twice. 

#foreach( $myList_c in $sorter.sort($myList_cList, "date:desc") ) #set( $mySortedList = $sorter.sort( $myList, ["field1"] ) )

 Considering, more than 1 millions data sets, will this behavior result into

1. email delivery to be delay more

2. soft bounces and campaign response result affected

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

Considering, more than 1 millions data sets, will this behavior result into

1. email delivery to be delay more

2. soft bounces and campaign response result affected


I would have no concerns about sorting a list of < 100 items twice, rather than once, in a single email assembly. The overhead is infinitesimal.

 

However, sending 1,000,000 emails at once is a decision not to be taken lightly, regardless of what Velocity functions you call. Be prepared to be throttled and/or to have a high bounce rate, nothing to do with VTL.

2 replies

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
May 29, 2020

Considering, more than 1 millions data sets, will this behavior result into

1. email delivery to be delay more

2. soft bounces and campaign response result affected


I would have no concerns about sorting a list of < 100 items twice, rather than once, in a single email assembly. The overhead is infinitesimal.

 

However, sending 1,000,000 emails at once is a decision not to be taken lightly, regardless of what Velocity functions you call. Be prepared to be throttled and/or to have a high bounce rate, nothing to do with VTL.

Darshil_Shah1
Community Manager
May 29, 2020

If you use a lot high end velocity scripting for lead involve Custom Objects and their properties into the script and perform sorting and filtering math operations. Those high-end features can add latency in email delivery as more processing has to be done these delays can range from milliseconds to even a few seconds, also the size your smart list for email send will also affect the processing time. Also regarding soft bounces, I believe a correct working scripting does not cause a soft bounce however a Velocity token parsing error does results in a Soft Bounce.