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
461 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,690 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
758 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
3,512 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
189 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,010 points
176 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
14 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
21 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,088 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.