Hello

When I click on a forum in the forums widget it takes a lot of time until the content is loaded and displayed. Sometimes it takes one minute and sometimes upt to three or four minutes.

Loading additional posts with infinite scroll enabled is very fast on the other hand. The normal network feed is loading pretty fast, too.

The query is very slow. ? Yes. I'm sorry @heluecht it's me and my DB again. ?

Is it just my node or do others experience the same?

The query:
# Time: 221216 17:00:42 # Query_time: 65.951453 Lock_time: 0.000055 Rows_sent: 20 Rows_examined: 37489 # Rows_affected: 0 Bytes_sent: 0 # Tmp_tables: 2 Tmp_disk_tables: 0 Tmp_table_sizes: 253976# Full_scan: No Full_join: No Tmp_table: Yes Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No use friendica; SET timestamp=1671210042; SELECT * FROM `network-thread-view` WHERE (`uid` = 2 AND ((`contact-id` = '2047239') OR `uri-id` IN (SELECT `parent-uri-id` FROM `post-user-view` WHERE (`contact-id` = '2047239' AND `gravity` = 3 AND `vid` = 7 AND `uid` = 2)))) ORDER BY `received` DESC LIMIT 20;