In order to improve the searching efficiency of certain, plans to user accounts , user name , user department joining together to form a search fields, demand is inserted in the update data or data use a trigger to search search field modifications to records of an object,
Also want to ask next, do so to frequent revision table insert change speed effect big?

CodePudding user response:

 also want to ask next, do so to frequent revision table insert change speed effect big? 

Not so slow, you said to achieve what kind of demand, after joining together the new fields, format requirements?

CodePudding user response:

Why not use the function index or virtual columns?

The table and trigger is a ticking time bomb, to avoid as far as possible,