in reply to Shredni Vashtar

@Peter Cannon not sure what you mean, but as said great support can be found in !Friendica Support, about the SSL, there is nothing special about that for Friendica, so just find some nice description on how to set it up for you system and webserver. There is so many unkowns that it is hard to support, you need to find some description that comes close to your setup.
in reply to Shredni Vashtar

Friendica does really require a reasonably well tuned database to function speedily, but https verses http really should not have any bearing on that. Suggest using the latest mariadb and follow instructions on their site for tuning. My database previously maxed out at 400 TPS, now it can handle spikes of 10,000 TPS, mostly by following instructions there. This only made a small difference for friendica but a huge difference for hubzilla which is not so well crafted in terms of it's database use (in particular it does a lot of large unindexed searches). For best results, don't try to run on a machine with just a few gigabytes of RAM, MariaDB works best when it mostly works out of memory which means throwing a lot of memory at it.
in reply to Shredni Vashtar

@Peter Cannon for max_allowed_packet is is hard to say, I just checked, for some reason I had it set to 256M, but that is too much. It is, as far as I understand, the maximum size that can sent/written to the database, so based on that, 32M or 64M should be plenty. Just my guess.

I think Steffen know better than I.