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 <pathoschild@gmail.com> 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.

[1]: main query

[2]: secondary query to fetch comment text

On Mon, 3 Jun 2019 at 14:51, Huji Lee <huji.huji@gmail.com> 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
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud