Efficient string search in Azure Table Storage column

Question

Are there any patterns for implementing efficient string search for Azure Table Storage?

Let's say there are a large number of rows and each of them contain a string column. Users should be able to perform a search based on the words in stored text. Azure Table Storage does not support this without loading all entries to memory. However, speed and low cost made me think about possible workarounds.

The only solution that comes to mind is keeping indexes of all the words. When entry is added/updated, indexes for it should be regenerated.

Maybe someone solved the same problem before? What would be your suggested strategies? Or is Azure Table Storage just not a good fit for what I am trying to accomplish?

Answer 1

There is now Azure Search for full text searching.