Comment by xmprt
> 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.