@Ruud
in reply to Ruud

Is it just the sheer number of users that swells the database or is it everything Friendica is pulling from other servers and caching?

My Dev Server isn't actually federated to any live sites, but I do have multiple versions of Friendica installed alongside each other and federated to each other for testing. So far none of their databases has become unwieldy but I bookmarked this blog page in case I ever need to figure out what is getting too big that needs optimizing.

I wish I knew more about databases. I've always been confused by SQL queries. I mostly search online to copy and paste and hope whomever wrote it knew what they were doing.

in reply to Daniel de Kay

@Daniel de Kay

I don't know of anything specifically for the next release.

There was a project to allow using a Postgres database, but it never got completed: github.com/friendica/friendica…

There is also an ongoing "Work In Progress" to refactor the database: github.com/friendica/friendica…

The latest piece of which is draft "Proof of Concept" PR regarding database abstraction: github.com/friendica/friendica…