by
8,516 31
4
6
2,796
1
Top 1% !
Popular
Famous
Easy-to-find
Specified
MultiPlatform
Popularity: 5646th place
DBMSMySQL
Languagesql
LicenseMIT_X11

Most efficient way to perform a FullText Search on SQL MS Azure

On Azure SQL Database the FullText Search is not enabled, so what is the best way to do a similar search with acceptable performances? Using LIKE operator is not an option for large databases...
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/121746/Most-efficient-way-to-perform-a-FullText?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
SQL Azure Database does not currently (August 2014) support Full Text Search. Many requiring this functionality have opted to use Lucene.NET instead. There's a useful overview of Lucene.NET plus code samples below: Lucene.NET Overview and Code Samples: http://leoncullens.nl/post/2012/11/18/Full-Text-Search-on-Azure-with-LuceneNET.aspx I was able to create a working demo against one of my own SQL Azure tables in about 10 minutes. var indexWriter = new IndexWriter(azureDir, new StandardAnalyzer(Version.LUCENE_30), true, IndexWriter.MaxFieldLength.UNLIMITED);

Question

If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus