I don’t follow the development super closely so I don’t know if those issues were resolved or not. I just remember a lot of discussion on it when I was first on Lemmy on a different instance.
not that i'm aware of, and fixing a database schema once it's already in place tends to be a clusterfuck so i'm very skeptical it will get better any time soon