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

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

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.

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.

Solid breakdown. The only thing I would add is to back up before making the change — better safe than sorry.

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.