Anybody ever been asked “What’s the expected latency of your DB queries ?” In a system design? Is this a fair question? I genuinely had no idea what kind of numbers to give, I’ve actually never even used SQL in real life lol. It was for an auction bidding system design, like EBay. Idea was a simple SQL server with some basic metadata about the highest bidder so far. Could’ve used KV store as wel but was just saying either one would probably work fine, but needed ACID capabilities for write protection so opted for SQL. Then got this question. I just said “probably less than 400ms” lol no idea TC: 400 YOE: 15
Amazon uses Dynamo even for transactional use cases. We might rather slap the DDB transactional library on top of DDB but it’s an exception to use Sql or any other stores
Can you elaborate on the DDB transactions lib? Never heard of it, does it provide full ACID capability?
Could it have been a hint that you need something faster, like a cache
They probably didn’t want exact numbers
15 yoe and you never used sql in real life? Bruh
Amazon is all KV stores in Dynamo my dude. That and my first decade wasn’t in web development. Also, I have never put SQL on my resume so…
you could interpolate, it should be obvious that latency are the same. Otherwise one of the db wont be existing