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...
post this code
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:
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);
If you want to be updated about similar snippets,
and follow our Channels