Geek Answers Handbook

Azure table query for multiple objects

I am writing an azure application. My questions are about querying the azure table for specific objects.

The application stores statistics of words used by users. The partitionkey table contains the language, and the row key is the word.

I need to request a few words. To speed up the process, I want to pull out all the relevant objects in one request.

I know how to “group insert” a group of objects having the same section group. How to query as 50 different objects with the same partition key but different rowkey.

Is it possible to specify the query as a string?

Hi

+4
source share
4 answers

You can specify up to 15 matches in $filter , so there are essentially 15 specific lines of lines if you omitted this route. Note. This will lead to viewing sections. The specifics of the queries are performed in this article .

More information on this StackOverflow question and related answers.

+1
source

But one request does not necessarily speed it up. Issue 5 queries of 10 words each (possibly in parallel) and combine the results.

+1
source

This is not a question that you asked, but you may find that you get the best performance from this particular request if you cancel RowKey and PartitionKey. I suppose there might be a lot of words in a language, so that would mean that you will have rather large sections. If you try to parallelize your request, as others have suggested (which is a good idea), all these requests will fall into the same section with your current key plan.

If you canceled the keys, although that would mean that getting a list of words for a particular language would be really quite inefficient.

+1
source

I don't know what an easy way to do this, but there are some dynamic LINQ query libraries that you could use.

You can check this question:
Parsing a C # LINQ expression string

And these libraries:
Dynamically generate LINQ query with custom property
Come up with your own LINQ dynamic analyzer

And this tutorial:
Dynamic LINQ (Part 1: Using the LINQ Dynamic Query Library)

0
source

More articles:


All Articles