This is just an informative post to let you know we released MailWizz 2.4.1, which contains considerable changes related to how we load data in segments that use the ANY operator and have more conditions.
Until this change, when there were multiple conditions, and the operator was set to ANY, loading data matching the segment was slow, but with the latest changes, we have improved this process. It is now up to 16x faster, which is huge.
We wrote about this in an article called Speed Up Your SQL: Using Unions for Faster Query Execution in case anyone is interested in the technical aspect that allowed this.
We have created special test cases in order to make sure this change does not break existing applications using segments that use the ANY operator.
However, as with everything, we might have not covered all the use cases, so if you are using segmentation in MailWizz and specifically you're using the ANY operator in your segments.
Until this change, when there were multiple conditions, and the operator was set to ANY, loading data matching the segment was slow, but with the latest changes, we have improved this process. It is now up to 16x faster, which is huge.
We wrote about this in an article called Speed Up Your SQL: Using Unions for Faster Query Execution in case anyone is interested in the technical aspect that allowed this.
We have created special test cases in order to make sure this change does not break existing applications using segments that use the ANY operator.
However, as with everything, we might have not covered all the use cases, so if you are using segmentation in MailWizz and specifically you're using the ANY operator in your segments.