Skip to main content


@Friendica Support Since #friendica version 2023.12 loading of my personal posts (the house icon) is very slow compared to all other feeds. Do others encounter that kind of behaviour?
in reply to Christian Kalkhoff

@Christian Kalkhoff I had it, too, until I have changed some mysql conf value to some 6GB if I remember correctly. I can't remember the name of that value but I can look it up when I am back at the PC.
in reply to Christian Kalkhoff

@Tobias Nice, those stick out:

Tag::populateFromItem (3248)
Media::getByURIId (3280)

Compared to the network feed the stack trace is also way more complex

in reply to Christian Kalkhoff

@xy.. Thanks, that helped... all the places that were "fast" before, so friendica is now really fast but for the profile posts. Thank you anyway!
@xy..
in reply to Christian Kalkhoff

I now run #mariadb with

--optimizer-use-condition-selectivity=1 --optimizer-switch='rowid_filter=off' --innodb-buffer-pool-size=6G --query-cache-size=64M --max-heap-table-size=64M --tmp-table-size=64M

That helps a lot overall, but the personal page is still about 8 to 10 times slower than everything else.

in reply to Christian Kalkhoff

@Christian Kalkhoff Just noting that it's not really weird for your own profile to potentially load a bit slower because it does do more work for that page in a lot of ways.

It's not just doing a query for posts, it's also doing:
* pulling up your contacts
* pinned posts
* tag cloud (I can't remember if this is optional somewhere?)

Friendica Support reshared this.

in reply to Christian Kalkhoff

It seems to me like pictures are loading slower, but maybe it just feels that way because they added a picture placeholder. It's been a while since I pressed the house icon. The "latest creation" tab seems to be my happy place these days.

Friendica Support reshared this.