the campaign link is sometimes slow to open

[ctorres]

Hi, when I send campaigns sometimes the links open fast and sometimes they take a long time to open, the destination servers to the websites where I redirect to have no problems, has anyone else had this happen.

I have also tried on other servers with other data centers and it is the same, currently it is fine, but sometimes it happens.

 

[wasif]

Sometimes, the delay isn't caused by the destination server, especially if you have a large database. To help with this, there's a helpful option in the Application settings under the Performance tab. This feature lets you process open and click tracking with a cronjob. As a result, all database operations will be handled afterward by the cron, so no database queries will slow down the redirection, as shown in the snapshot below.



Then check Settings -> Cron Settings to see if open/click tracking crons are not disabled.

 

[ctorres]

I understand, it is mostly because of the size of the content; maybe some process falls short or something is missing to improve. Can you guide me on how is the best way for a high performance environment? Is there any way to make it work with workers or multiple processes? The intention is to be able to use the databases and as it grows, scale the scalability if needed.

 

[wasif]

The growing database wouldn't be a problem if properly tuned. As I mentioned earlier, switch your open/click processing to cron-based, which enhances the real-time experience by handling database operations server-side. Also, under the performance tab, you'll find options to delete logs and other data after X days, which is highly recommended to keep the database optimized by removing stats you probably don't need. Furthermore, if your database becomes very large and you have front-end operations like many users navigating, you can consider a load-balancing solution. We already have an implementation that can handle crons running in parallel on multiple servers.