Campaign Processing Gets a Speedy Upgrade
In the upcoming 2.8 release, we made significant performance improvements for campaign processing. We worked on 2 areas:
- Campaign Item Generation
- Campaign Message Queuing
In both cases we refactored a great deal of PHP logic to SQL Stored Procedures and functions to increase performance. For Campaign Item Generation, it previously took 75 seconds to process 500 items. With the new improvements, it now only takes 0.0063 seconds. We went from 6 items per second to now 80,000 items per second. That is a major turbo boost.
For Campaign Message Queuing, previously a single message took 20 seconds, but now it only takes 0.8 seconds. The performance tweaks would equally improve Auto-responder outbox queues as both jobs use the exact same utils.
Enjoy all the extra time you will be saving and don’t go spending it all in one place.