• when the distributor buys, the performance automatically adds up to all his superiors" monthly performance
• the settlement method determines whether the minimum settlement ratio standard is met according to the total performance of the current month, and the settlement is made from the top level to the next level.

how to deal with this to achieve the optimal (can not frequently operate the database), each settlement of a person, need to save his settlement record; then zero the profit characters of the hierarchical relational table; solve!