That was a nice comment, thank you! I didn't knew the database implementation of lemmy was so much worse than piefed one, though, i doubt i am gonna switch to piefed because of some opnions that the devs have and i don't want to support
Edit: another consideration is whether you want to host your own instance. For that I would unhesitatingly recommend PieFed as by far the easiest to deploy (especially via the docker container) and using least resources. Tbf, that is not from 1st-hand experience but so very many reports of others do state this.
That's not something i am gonna do (for now!) because i just don't have the hardware, though, i once tried to make a lemmy instance and it was such a mess!