Is this behavior in troubleshooting expected?

We ran into the same situation last quarter. What worked for us was starting small and only adding complexity when a real need showed up.

One caveat for larger communities: keep an eye on the indexes. At a few thousand rows the difference is night and day.

This is the answer I wish I had found six months ago. Would have saved me a weekend of trial and error.

Great point. I had not considered the angle you raised in the second paragraph — it reframes the whole thing for me.

This deserves more votes. It is a small change with an outsized impact on day-to-day use.

This matches my experience exactly. The hard part is staying consistent once the initial novelty wears off.