Feature proposal #8953closed
Redesign notification storage to a relationship table
This should result in a one-to-many relationship table. 1 notification row exists followed by a relationship table noting the recipients. The recipient table is a small fast user_id | notification table. This allows sending 1 notification to 100 users if necessary in an extremely efficient way.