DynamoDB BatchGetItem vs Query

0 votes

These two approaches of querying are very similar can someone help distinguish them better? I know the size of retrieval in each case differs, are there any other differences?

Apr 17, 2018 in Cloud Computing by hemant
• 5,810 points

1 answer to this question.

0 votes

To a large extent I agree these two appear very similar. But must say these two different in some aspects lets take a look at those:

Firstly if your concern is bulk dumping then use BatchGetItem if it is sorted retrieval or in better words narrowed down retrieval stick to Query.

Let’s talk of size of retrieval which you mentioned in the question. BatchGetitem retrieves 16mb or 100 items. Whereas Query will give 1mb of data in response.

Next how do these two queries retrieve data? Well, BatchQueryItem uses hashkey for identification of items whereas Query uses secondary or global indexes.

One important difference between the two is Query supports filter expressions.

I hope this helps.

answered Apr 17, 2018 by code_ninja
• 6,290 points

Related Questions In Cloud Computing

+3 votes
5 answers

AWS EFS vs EBS vs S3 (differences & when to use?)

EFS is: May not yet be available in ...READ MORE

answered Apr 9, 2018 in Cloud Computing by hemant
• 5,810 points
+2 votes
10 answers

Querying DynamoDB by date

You can use the "day" portion in ...READ MORE

answered Oct 25, 2018 in Cloud Computing by abc
0 votes
1 answer

What is the difference between AWS S3 Bucket Log Vs AWS CloudTrail

Let me give you a few pointers: In ...READ MORE

answered Apr 19, 2018 in Cloud Computing by brat_1
• 7,200 points
0 votes
1 answer

AWS trusted adviser vs Inspector

AWS is a web service by Amazon ...READ MORE

answered Aug 3, 2018 in Cloud Computing by ArchanaNagur
• 2,340 points
0 votes
1 answer

How is AWS DynamoDB different from other AWS Databases?

Hi vishal, Amazon DynamoDB is a nonrelational database ...READ MORE

answered Oct 30, 2018 in Cloud Computing by remo12
0 votes
2 answers

Hybrid Cloud vs multi-Cloud

Hybrid cloud is an infrastructure while multi-cloud ...READ MORE

answered Feb 8, 2019 in Cloud Computing by sarosh
+2 votes
3 answers

AWS trusted advisor vs Inspector

AWS Inspector leverages agents installed on EC2 ...READ MORE

answered Sep 28, 2018 in Cloud Computing by Taimoor
0 votes
1 answer