问题描述
我移动的.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：的磁盘驱动器，但你必须在定义文件中声明，并通过调用 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.
另一种选择是使用天青硬盘，但请记住，ONY一个实例可以写入。
Another option is to use Azure Drive, but keep in mind that ony one instance can write to it.
这篇关于实现SQL Azure的搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！