Comment by xmprt
1 day ago
> Most queries should take max 20-30ms
Most queries are 20-30ms. But a worst case of 200ms for large payloads or edge cases or just general degradations isn't crazy. Without knowing if 500ms is a p50 or p99 it's kind of a meaningless metric but assuming it's a p99, I think it's not as bad as the original commenter stated.
They mention later in the article that the 500ms is p75.
Realistically 50ms p75 should be achievable for the level of complexity in the shopify app.
P75. I can only image the p90 and p99 are upwards of 1 second.
Agreed. The P95 and P99 in particular are likely to be over 1 second, possibly over 2. They chose P75 to be able to post a seemingly impressive number.
I personally wouldn't be very happy with a P75 of 500 ms. It's slow.
Ah. I see we are spoiled with <4ms queries on our database. See, it all depends on perspective and use case. :)