What is "Counting in progress" and how to accelerate this?

[god_prophet]

We have a delivery, where the workflow started at 10 am and contact date is "inmidiatlt". But it is still in Counting in progresss... what is it: Is counting all the recipients?

Is there any configuration, we can apply to accelerate this next time?




It seems audit is not updated, and showing last action at 10 am, when it is 4 pm.

[Marcel_Szimonisz]

Hello @god_prophet ,

when delivery is executed there is bunch of things happening one of which is "counting in progress" where all your filtering typology rules are applied.

If you are using custom filtering typology rules they may slow the process, so if you do so you should optimize them.

But that time is way too long. Have you refreshed the page btw 🙂

Marcel Szimonisz

[LakshmiPravallika]

Hi @god_prophet ,

Please check whether the recipients have received the delivery in your delivery logs or else workflow restart is required if not received the emails.

Also, the SQL Typology rules needs to be optimized(if filtering is done on a column, please create an index on it to faster the selection ),and also if it is an external Database to which these are applied, it can also slow down the performance.

Regards,

Pravallika.

[Craig_Thonis · Accepted solution]

Hi ogonzalesdiaz,

Counting in progress is similar to the personalization step. It counts the recipients but also ensures that the expected count is the same as the actual count. If the count is misaligned, an error will be thrown, and the delivery will fail.

The count could fail due to personalizations being called within the delivery that incorrectly leverage a 1-N table and cause the number of targeted recipients to be inflated.

The preparation step heavily interacts with the database. So, if you want to improve this step, there are numerous optimizations:

1) Check the current delivery content and ensure that any personalization or count requests within the content are properly joined on keys and not doing full table scans

2) Ensure referenced tables are indexed

3) Ensure that the database cleanup workflow, maintenance scripts, and temp space are cleaned

If you are still unable to determine the problem, I recommend turning on SQL logging to see what queries are being executed and then either reach out to your database administrator or to Campaign Support, who can review the queries when the delivery is executed. This way, they can see if an inefficient query is being executed or perhaps there is another conflicting query from another workflow that is locking the table and causing delays in the count.

Regards,

Craig

[god_prophet]

Hi Craig, how to do step 1? Any tutorial or guide?

Thank you.