lemmy internally has SQL flaws that have not gotten much attention. A few days ago, over the weekend, lemmy.ca people studied some of the SQL and exposed a problem where every single new comment and new post on a local server updates 1500 rows in a database table where it should be updating just 1. There have been similar runaway SQL statements discovered. Fixes for the most recent issue are already on GitHub waiting for merge and publication.