this query takes ~30 seconds. Seems abnormal to me
-
The result is really large...maybe it just takes that long...– jjnguyAug 26, 2010 at 18:08
-
This query returns almost instantly.– jjnguyAug 26, 2010 at 18:14
-
@jjn - yeah. but seems to me that fetching with answers comments and body did not previously demonstrate such latency but I have no metrics. thanks for the perspective.– Sky SandersAug 26, 2010 at 18:43
1 Answer
Its slow because the response is so large, and it touches a large amount of data per-question (all answers and comments, by definition).
Its equivalent to visiting every question on the first couple pages of SO, after all.