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?
#friendica @Friendica Support
in reply to Christian Kalkhoff

xy..
xy..
•
@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.
@Christian Kalkhoff

Friendica Support reshared this.

in reply to Christian Kalkhoff

Tobias
Tobias
• •
Hey Christian, could you activate the "rendertime" addon on your node? It will display time sinks at the bottom of the pages shown (to the admin user). Please activate the "Show callstack" option in the addon settings (in the admin panel) and set the minimal time to 0.01 seconds. This will limit the noise as only things that take longer then 0.01 seconds are shown.
in reply to Christian Kalkhoff

Christian Kalkhoff
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

@Tobias

Friendica Support reshared this.

in reply to Christian Kalkhoff

Christian Kalkhoff
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..

Friendica Support reshared this.

in reply to Christian Kalkhoff

Christian Kalkhoff
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.

#mariadb

Friendica Support reshared this.

in reply to Christian Kalkhoff

Shiri Bailem
Shiri Bailem
• •

@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?)

@Christian Kalkhoff

Friendica Support reshared this.

in reply to Christian Kalkhoff

Lorraine Lee
Lorraine Lee
•
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.

⇧