I have try to imagine a convenient way to do this, but it seem to me there is not one.
The problem could be minimized letting only a restrict user group to use this feature, and with limited words.
Imagine a forum where 10000 users set this kind of feature, and when post insertion happen, the query should:
search for each user that had setup, let say one or two keywords, the match on the text.
It would be quite intensive into a text, to search for 10000 or 20000 words if there is some match for those values on the post content. And if users using the feature are 300000?
Adapting the code to get an unique array of values to check against would be not a good solution.
It should be the reason why, socials, let subscribe to specified arguments, which who post may add as tags.
Differently, i am asking myself if can exist a "convenient way" and if my assumption is right. Seem impossible in a convenient way.
Which, to you, could be a medium limit, so that providing an array of words to check against, it would overload the system? (i know this question depend by many factors!)... and well, to associate each word to users is hard.
Easy and possible would be if only certain words are set, and users with no possibility to change values/words
Thank you for your comments
[EDITED]
- notifyByWords Module.png (7.78 KiB) Viewed 740 times