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.