My client wants to create a filter decision split within the journey in a field that contains 4000 characters, with the operator CONTAINS. The question is: whats is the efficiency of performing this operation when we are injecting around 2M of contacts? Will it work out well or is there any problem with processing of this much data?
5
-
Will you be manually injecting 2 millions contacts, simultaneously? is it just a single contain operator? Would you be able to handle this at the SQL layer instead, so that you could use the Equal to operator in the decision splits?– Kenneth WagnerCommented Jun 22, 2017 at 9:10
-
Yes, it would be injected simultaneosly, and would be a single decission split, where the idea is to find the keyword contained within the field. The idea of doing through sql is not good because the user dont have tech knowledge to perform a query, so, its possible to process this volume of data?– JonatanCommented Jun 22, 2017 at 11:43
-
Any requirements on processing time?– Kenneth WagnerCommented Jun 22, 2017 at 12:19
-
Yes it would be a must to proccess the data asap, but from my knowledge i dont know how much it costs in terms of time... if anyone know or have tested the process would be very helpful..– JonatanCommented Jun 22, 2017 at 13:48
-
1Don't believe JB would work. Per IP, i believe marketing cloud sends out 2-3 million emails Per hour, 10-15 million with burst sending. And you are adding entry and decision splits on top of that– Kenneth WagnerCommented Jun 22, 2017 at 15:33
Add a comment
|