As title, turn to the great god answer, thank you!

CodePudding user response:

It is best not to use the database to solve this kind of demand,
If you use a database, at least need to control the amount of data after each fuzzy matching, otherwise the control performance is bad, but this is almost impossible

CodePudding user response:

Agree with upstairs point of view, and at the same time in the fuzzy matching, had better take a date, number and so on to narrow the scope of the data

CodePudding user response:

To specific host the problem so that demand, in particular SQL, still there is room to optimize,

CodePudding user response:

If only in a database to run, to consider the where, in the conditions of other fields is available on the index, in short, narrow down the result set access,
Is only a full table scan, can consider to add parallel query, give full play to the ability of multi-core CPU, according to the number of CPU cores, and load,

CodePudding user response:

references to freedom and responsibility, 4/f, reply:

, if only in a database to run, to consider the where, in the conditions of other fields is available on the index, in short, narrow down the result set access,
Is only a full table scan, can consider to add parallel query, give full play to the ability of multi-core CPU, according to the number of CPU cores, and load,

Parallel because direct physical mechanism, the hardware resources, especially the requirement of storage is too high, if the query of concurrency is higher, the database will be dragged down,

In fact, the original poster can consider in ES, Redis tools such as positioning, first by positioning to return such as ID or name of the database query,

CodePudding user response:

If you use database optimization, consider using this approach, is to transfer the whole table scan to the whole index of fast full sweep on,

CodePudding user response:

This from the perspective of business to deal with, sometimes in a different way to solve the problem, this is not a database strengths,