实现SQL Azure的搜索 [英] Implement search in Azure SQL

问题描述

我移动的.NET应用程序到Azure存储以来的数据量越来越大，并发用户越来越多。为了能够搜索我需要一个强大的解决方案要搜索的缩放SQL。

I'm moving an .NET application to Azure since the amount of data stored is getting bigger and the concurrent users is increasing. To be able to search I need a robust solution to search the SQL which scales.

我需要返回（在一个单一的领域，谷歌风格）搜索时，匹配的订单。数据存储在这些相关的表数列：订单，客户和地址。

I need to return matching orders when searching (in one single field, google style). The data is stored in a few columns in these related tables: Orders, Customers and Addresses.

我读过全文搜索是不是在Azure中可用，因此我已经看了ATT Lucene的，但有一点担心存储在一个BLOB索引。它似乎没有权利打Blob存储在每个搜索。

I've read that fulltext search isn't available in Azure so I've looked att Lucene but got a bit worried about storing the index in a blob. It doesn't seem right to hit the blob storage at every search.

有没有人对如何做到这一点我一条有效的途径？任何建议

Does anyone have any suggestions on how to accomplish this i a robust way?

推荐答案

我们使用的Solr / Lucene的最佳全文搜索结果。索引的数据存储到本地存储的（高达2 TB） 。

We use Solr/Lucene for best full-text search results. Indexed data is stored into local storage (up to 2 TB).

本地存储像的 C：的磁盘驱动器，但你必须在定义文件中声明，并通过调用<一大家参考吧href=\"http://msdn.microsoft.com/en-us/library/microsoft.windowsazure.serviceruntime.roleenvironment.getlocalresource.aspx\"相对=nofollow> RoleEnvironment.GetLocalResource 。

Local storage is like c: disk drive, but you must declare it in the definition file and get reference to it by calling RoleEnvironment.GetLocalResource.

如果你想加快启动时间（最初全索引）你可以保存/下载索引数据持久Blob存储。

If you want to speed up startup time (initial full index) you can save/download index data to persistent blob storage.

另一种选择是使用<一href=\"http://download.microsoft.com/download/9/7/0/97097468-CD68-4FD6-967D-C6C99B39A498/Windows%20Azure%20Drive%20-%20February%202010v2.pdf\"相对=nofollow>天青硬盘，但请记住，ONY一个实例可以写入。

Another option is to use Azure Drive, but keep in mind that ony one instance can write to it.

这篇关于实现SQL Azure的搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！