I need help customizing the query for my combination search. I have a string and value I have a search ( Hello World) Now the program needs to search in the 7 fields for value Hello and then again in this 7 fields it is necessary to search again. If there is a field in the world, then I have 1 in the field of greeting and one or the other The world in the field i At the time I discovered that it is 50000 rows and more every day. At this time I split the search condition into space, then I have an array of search syndication. I use 7 for every search in this array or add it to the query string. So my quizstring is very large and there are many or many in it. Now I want to customize my query and code so that I get a quick result of the query. Operators very fast - many columns and mounting table sizes are given.
I recommend that you Look at the fulllight service + index on your DB and instead use your fulltext index to do your search.
Reference:
Comments
Post a Comment