Geek Answers Handbook

Efficient row lookup in Azure table storage column

Are there templates for efficient row searches for storing Azure tables?

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

The only solution that comes to mind is to maintain the indices of all words. When a record is added / updated, indexes for it must be restored.

Maybe someone solved the same problem before? What will be your proposed strategies? Or is Azure Table Storage just not suitable for what I'm trying to accomplish?

+4
source share
2 answers

Azure Search now exists for full-text search.

+5
source

So far, the answer to your question is exactly what:   Azure Desktop Storage is just not suitable for what I'm trying to accomplish. But it’s very useful to be able to quickly search in your model.

Last time I do the same thing that you suggest: using indexes to place keywords in a separate table. The only negative value here is that you cannot perform transactions between table update operations and the indexing operation.

, , PartitionKey RowKey (concat ..)

0

More articles:


All Articles