I have a CSV file with 3x10 ^ 6 rows, the title and most of the body, the text file has 3GB +.
I am a little afraid of the fact that almost all the data to be seized will be fake, can someone advise me that any advice on the benefits of the MyScall fulltext index on the title, body column Give?
After detailed investigation, I found that the search work has not been fully implemented in theory.
Therefore, if you use searchable, you only get an index table. After that, you should write your function to use that table with a complex search query. The principle is just a basic search Provides a function that can only search one keyword. (The way I'm talking about principle 1.2, I'm not sure whether the principle is 2.0).
On the other hand, MySQL Full Text Search has everything for you, you can easily use Boolean searches.
Comments
Post a Comment