Menu
Data in sql azure, we have an existing webapi expose the data with odata. Issue is client want to make a call with filters with substring query on a few columns, which making performance really slow. we are debating at this point whether to use full text search index or use the azure search service, thoughts please?
883
Full-Text Search is available in Premium, Standard and Basic service tiers in Azure SQL Database V12. You can start using it immediately on your databases as there is no other service configuration necessary.
Select columns name and language types for columns. You can only select character based and image based columns. Select change tracking. Now select the full-text catalog for index.
In Azure Cognitive Search, a search index is your searchable content, available to the search engine for indexing, full text search, and filtered queries. An index is defined by a schema and saved to the search service, with data import following as a second step.
What is a Full Text Index? A full-text index is a special type of index that provides index access for full-text queries against character or binary column data. A full-text index breaks the column into tokens and these tokens make up the index data.
Some of the considerations and tradeoffs between hosting search in Azure Search vs. using SQL Server FTS are captured here.
As pointed out above, Azure Search can index in-database data - see Connecting Azure SQL Database to Azure Search using indexers.
60
You can point Azure Search at your AzureSQL database and it will index it without you having to write code, but Azure Search is a service you have to pay for on hourly basis and you can learn more information about it here.
Azure Search is recommended for performing searches on various sources and application
Azure search can be used instead of Full-Text search, but If you need to join search results with other tables, then Full-Text Search is recommended.
Hope this helps.
26
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
