Monday, January 27, 2025
1 change
Enhancements to existing features
This update adds database optimizations that help WhatsApp message cleanup and related marketing tracking run more efficiently. It reduces the chance of slowdowns when processing large volumes of marketing automation and WhatsApp data, without changing user-facing features.
Original PR description
Missing indexes: - `whatsapp.message.parent_id` is hit during Fkey lookup during unlinking to set the value to null during `whatsapp.message`'s GC. - `marketing.trace.whatsapp_message_id` is the inverse of the One2many `marketing_trace_ids`, index will be hit when the ORM reads the O2m field. `marketing_trace` is usually a large table, a `Seq.Scan` should be avoided. Would also be hit during whatsapp's GC