My Mautic version is: 4.1.1
My PHP version is: 7.4
My Database type and version is: mariadb 10.3
My problem is:
We are running an extremely high traffic site with 1000+ visits per hour and are running into latency issues with segment update.
Example we have a campaign that is based on anonymous users hitting a certain page. This campaign is based off a segment that captures anonymous users. The problem is inside Mautic we also have 80+ segments some of which are a few hundred thousand users.
So what is happening is that this aparticular segment is actually taking around 10 minutes to update which rendors the focus item campaign useless.
Now I can go ahead and use Mautic:segments;update -i [segment id] to run specific segments that take very long only once a day for example, but this means that for my cronjob that is running every minute * * * * * php /var/www/mautic/bin/console mautic:segments:update will update all segments, is there a way to do a "negative here " ?
I mean we are running a pretty strong server with 32GB RAM, 8 CPU, and still taking forever to update segments