All geek questions in one place

MS Sql Full Text Search vs. LIKE Expression

I'm currently looking for a way to search for a large database (500 MB - 10 GB or more on 10 tables) with many different fields (nvarchars and bigints). Many of the fields to look for are not in the same table.

Example: a search for "5124 Peter" should return all elements that ...

  • has an identifier with 5124 in it,
  • there is "Peter" in the title or description
  • has an item type identifier with 5124 in it
  • created by user with the name "peter" or with user ID 5124
  • created by the user with '5124' or 'peter' to his address.

How do I search? I read that full-text MS-Sql search is much more efficient than a query with the LIKE keyword, and I think the syntax is clearer, but I think it cannot find the bigint (id) value, and I read that it has problems with indexing and therefore slows down inserts into the database. My project will have more insertion than reading, so this may be a question.

Thanks in advance, Marks

+3
source share
3 answers

, MS SQL; , /, , .

Apache Solr (http://lucene.apache.org/solr/), Lucene (http://lucene.apache.org). Solr Lucene, , ( 1 1, 3, 7 ..) Solr - , in-a-box, , , . Lucene .

Solr , -, , Java, Solr . Solr, # http://wiki.apache.org/solr/IntegratingSolr .

+1

, ​​ Sphinx Search:

http://www.sphinxsearch.com/index.html

Apache Solr:

http://lucene.apache.org/solr/

+3

, . , , , , , . bigint varchar, , , , , varchar. SCHEMABINDING , , .

, , 3301470 stackoverflow, - , sql 2005, sql 2008 . , , ( 2008). 2005, .

0

Source: https://habr.com/ru/post/1749919/

More articles:


All Articles