Dannymh
Active member
Hi,
I just wanted to see the sentiment on using MySQL triggers within an addon or generally with xf?
What I'm starting to code and dream up will be a fairly deep analytical tool for xenforo, whilst it can be done fairly easily with code event listeners, it can be done with a lot lighter load and queries if it is done via triggers.
I don't want to run against the grain if the preference is to not use triggers but I feel like using the code event listeners may end up causing a higher load for this kid of analytics and warehousing.
Thoughts?
Cheers
Dan
I just wanted to see the sentiment on using MySQL triggers within an addon or generally with xf?
What I'm starting to code and dream up will be a fairly deep analytical tool for xenforo, whilst it can be done fairly easily with code event listeners, it can be done with a lot lighter load and queries if it is done via triggers.
I don't want to run against the grain if the preference is to not use triggers but I feel like using the code event listeners may end up causing a higher load for this kid of analytics and warehousing.
Thoughts?
Cheers
Dan
