A data table, field as A string Name and Flag, this table has thousands of records, from hundreds of articles on whether to retrieve the contains A Name, if any, will be the corresponding Flag logo + 1, for example in the article A contains NameA, FlagA value + 1, if the article also includes NameA B, FlagA value + 1 again; In the article A contains NameB, FlagB value + 1, if the article also includes NameB B, FlagB value + 1 again,,,,,,,

A fast and efficient algorithm

CodePudding user response:

Article ES inside and then recharge to the retrieval results data table

CodePudding user response:

Update directly select fuzzy name, it's difficult to update flag?? instantaneous

CodePudding user response:

If you want to search a fixed term, can be used to calculate the column to realize efficient,
If not fixed, the database is nothing special and efficient way, is purely a table scan,

ES fast, but also need you to hold, also not the database category,