Small experiment, part 2: using the same method as in, we fetch 399 random public accounts. 95% time is 771 ms for the first run (no cache), 261 ms for the second run (warm cache). ("Before" numbers: 2803 ms and 243 ms).
Now cold accounts are much warmer, but warm got slightly colder? :) ‎· Count Caturday
Small experiment, part 3: 95% quantile is now 749 for the first run (JSON, no cache), 107 ms for warm cache, 215 ms for HTML and warm cache. ‎· псы в рапиде