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