Because we want to combine all the basic information of a piece of data into a field, and then use like to perform fuzzy queries, the speed of data processing is a little slow. Is there a more efficient way than like, is it feasible to add an index to this field? because we combine all the basic information of a piece of data into a field and then use like to perform fuzzy query, the speed of data processing will be a little slow, is there a way that is more efficient than like? is it feasible to add an index to this field?
Reply content:
Because we want to combine all the basic information of a piece of data into a field, and then use like to perform fuzzy queries, the speed of data processing is a little slow. Is there a more efficient way than like, is it feasible to add an index to this field, newcomer
Adding an index can improve the efficiency of like '% xxxx % '.
What else do you want to check?
Like 'xxxx % 'will hurry up
Sphinx
