Coffee or tea while you work?

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

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.

I respectfully disagree on one detail. In my setup the opposite held true, though I suspect it comes down to community size.

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

Appreciate the clear steps. The dry-run tip in particular saved me from a mistake I would not have caught otherwise.