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,750 points
557 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 5,920 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,750 points
875 views
+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
4,199 views
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,080 points
208 views
0 votes
1 answer

AWS trusted adviser vs Inspector

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

answered Aug 2, 2018 in Cloud Computing by ArchanaNagur
• 1,790 points
194 views
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
17 views
0 votes
2 answers

Hybrid Cloud vs multi-Cloud

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

answered Feb 8 in Cloud Computing by sarosh
22 views
+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
1,156 views
0 votes
1 answer

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.