Rooting for you! Friendica is by far my preferred way of accessing the Fediverse – and it seems .world is the largest European server on the whole platform, so I really need it to work, aaaaa
Thanks! We're doing our best. But we also need the github issues solved by the devs. Or others with programming skills
Commit is in: https://github.com/friendica/friendica/pull/14974
Yes I saw. Looks like they only addressed the example query I provided, and not all 'NOT IN' queries.. looks like I have to submit an issue for every query I find.
Do you have a test instance to check whether the recent change does help?
Yes we do, but it doesn't have the users.. so it can't really be compared.
I really like the local feed! I miss it already.
My instance only has 387 users, but these queries plague mine as well, locking tables for very long times, causing huge stalls.
@Jerry In the RC/Develop there is the fix that changes one of the ugly queries. Also it contains a coding to prevent executing long queries when another long query is running.
This is great! Can't wait for the new release! Thanks.
Are there some other friendica based sites experiencing similar problems ?
Not really, there are no Friendica sites with this many users...
There is squeet.me with 4,6k users: https://fedi.wrm.sr/instance/squeet.me comparable to the 4k users of friendica.world.
Ah I didn't know that one, they only have 80 mnthly active users though. I'll see if I can contact them
@ruud @convene_depth It's one of my servers. The active users there are a lot of news bot accounts, besides some users. AFAIK the server runs quiet stable, but I had to tweak the database a lot to make it work.
Also there are some tweaks in the setting (like reducing the number of delivery retrials) to make the system work faster.
Maybe after I upgraded to the RC we could schedule some time to go over your tweaks together?
@ruud We can try. I will be on the HOA until Saturday. Because of that I'm not sure how available I will be in that time.
Continuing this on Matrix.
Now that 2025.07RC is out had you considered updating to that?
Yeah, I might as well. Normally I'm reluctant to install RC's but it can't get much worse ;-)
Please give 2025-07RC a try as main dev was explicitly suggesting that.. And they were asking for Slowquery-log. Could you provide that after updating to RC?
Will do. Creating extra backup first before upgrade.
This community is for status, support and issues on the Friendica.World instance