This is a prime example of over normalization. We are normalizing and making things slower.

On Mon, Jun 3, 2019 at 3:38 PM Jesse Plamondon-Willard <> wrote:
Sure! I just fetch the comment ID in the original query ([1]), and fetch the comment text with a separate query ([2]). You need n+1 queries based on the number of records, but the performance is adequate for my use cases.

On Mon, 3 Jun 2019 at 14:51, Huji Lee <> wrote:
Out of curiosity, Jesse, can you share the query after that change, so it is all stored in this thread for future reference?
Wikimedia Cloud Services mailing list (formerly