Imagine that one of the DBs for your app suddenly had 100ms added to every call. You need to access this DB currently 1 to 30 times per transaction.

What would you do to compensate for this added latency?

2
Share
Share on Mastodon
Share on Twitter
Share on Facebook
Share on Linkedin
Jamie Gaskins

@nateberkopec I'd open a ticket with my DB provider and have them fix the latency. 😄

Alternatively, assuming it's a SQL DB, replace cascading queries with a single query with JOINs. For a DB more like Redis, restructuring data to be nested and pipelining queries to mitigate the latency cost. Maybe cache a little more.

0
8d
Damax

@nateberkopec remove non mandatory calls. Eg: number of items in the cart

0
4d
Replies