4 ms·
I recently finished a contract at a company who has gone full on dynamo with the idea that if we have slow queries and dynamo is good for Amazon, then it's good
by mickael-kerjean 2y ago
I recently finished a contract at a company who has gone full on dynamo with the idea that if we have slow queries and dynamo is good for Amazon, then it's good for us too. I've ran some explain on the queries causing issues and of course those queries didn't leverage indexes like they thought ....
- redditor98654 2y agoHow did you run explain queries on DynamoDB? Or may be you mean something different and I misunderstood you?
- mickael-kerjean 2y agoI ran explain on the original mysql implementation. The basis of the migration project to dynamo was mysql couldn't cope with our scale but that was bullshit
- bdavisx 2y agoThat doesn't make sense, you have to specify the index when you're using Dynamo.
- scarface_74 2y agoYou can do scan operations and if they use PartiQL it hides whether you are using indexes. I usually have an explicit DENY for dynamodb:Scan for the IAM role used to access the DDB table