Having a setup now, where multiple q2a installations (let's call it "network") run on the same database, with different prefixes (but shared user database), I want to achieve a "network" wide notification for events.
The events are stored per site (according to the prefix), for instance:
Having the on-site-notifications plugin installed, it only checks for the events on the according site, but not network wide.
My question: Should I simply modify the on-site-notifications plugin to read all eventlog tables?
Or should I create another way of handling those events, e.g. storing all new events in a unified qa_notify_eventlog table?
What would be best practice, especially with eyes on speed.