Conversation

Notices

1. Embed this notice
   hypolite (hypolite@friendica.mrpetovan.com)'s status on Saturday, 17-Dec-2022 03:56:30 JST hypolite

   in reply to

   • alfred
   • heluecht
   @alfred @heluecht Forum feeds have always been slower to load than my regular network feed as well. Not to that extent, but it's significant.
   • Embed this notice
     alfred (alfred@libranet.de)'s status on Saturday, 17-Dec-2022 03:56:31 JST alfred

     • heluecht
     • Friendica Support
     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;