Geek Answers Handbook

SQL Server and Regular Expressions

Which will be better among the following options?

  • SQL Server searches for regular expressions since newer versions support CLR objects?
  • Full text search?
  • Lucene.net combined with SQL Server?

There will be millions and millions of records in our database, and we will provide a Google-like search option, and, like Google, we will search only certain categories.

Please, help.

+5
source share
3 answers

  • Regular expressions are beautiful as long as your data is small, very small.

  • SQL - . , , Lucene.Net. , .

  • Lucene.Net / , , , Lucene.Net , . , , , . Lucene.Net.

.

  • .
  • SQL Server - , .
  • Lucene.Net , , ( ).
+6

. , .

Lucene - , , , SQL Server .

+3

, SQL Server, lucene.net SQL Server.

+2

More articles:


All Articles