Slow SQL Queries

[DarkDau]

Very long runtime of SQL Query

news Version 25.2.1

2 combined indexes are missing:
Limiting Title to 255 is necessary to avoid the following error:

1071 - Key is too long. The maximum key length is 3072
{.is-warning}

ALTER TABLE oc_news_feeds
  ADD INDEX idx_feeds_userid_deletedat_title (user_id, deleted_at, title(255));

and

ALTER TABLE oc_news_items
  ADD INDEX idx_items_feedid_unread (feed_id, unread);

Conclusion: The query no longer appears in slow_query.

Much more important is that the news application within nextcloud now seems to have been replaced. Because before the first call was very lame, as I see now, that was exactly the reason, maybe the query was always triggered when you connected to the app after a certain time, now it is in the range of 1-2 seconds.