]> git.mxchange.org Git - friendica.git/commitdiff
New query parameter that Speeds up the network viee when there are many contacts
authorMichael Vogel <icarus@dabo.de>
Sat, 24 May 2014 09:01:52 +0000 (11:01 +0200)
committerMichael Vogel <icarus@dabo.de>
Sat, 24 May 2014 09:01:52 +0000 (11:01 +0200)
mod/network.php

index 585c063f567da09689fbc9567606f09a3abd4694..ab44073508c572dba438a74b753a8944f7e7a5eb 100644 (file)
@@ -710,7 +710,7 @@ die("ss");
                        );
                } else {
                        $r = q("SELECT `thread`.`iid` AS `item_id`, `thread`.`network` AS `item_network`, `contact`.`uid` AS `contact_uid`
-                               FROM $sql_table $sql_post_table INNER JOIN `contact` ON `contact`.`id` = `thread`.`contact-id`
+                               FROM $sql_table $sql_post_table STRAIGHT_JOIN `contact` ON `contact`.`id` = `thread`.`contact-id`
                                AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
                                WHERE `thread`.`uid` = %d AND `thread`.`visible` = 1 AND `thread`.`deleted` = 0
                                AND `thread`.`moderated` = 0