Correct me if I'm wrong, but rules constrain the SQL (ie. validation).
Triggers are carried out after the SQL is executed and the data is modified.
So, to answer your question, I think rules come first. As to which order
the rules / triggers are executed probably depends on the order you put them
allows regexes in the where clause (ie. rlike in mysql)
but with that you can "find all nodes 3 or more leaves down from node 123"
or even weirder stuff. We have trees with 60,000 nodes 30-40 levels deep.
Queries on the tree take very little time at all.
Adam Erickson
-
