SQL speed increase for query and search.

[friendica.git] / include / api.php

diff --git a/include/api.php b/include/api.php
index 06dbca7f143ad9911702c02292ad1fbb5d03b346..a9e0edc80836f00d0fcbf4ed762ea6f794996ce2 100644 (file)
--- a/include/api.php
+++ b/include/api.php
@@ -1162,7 +1162,7 @@
                if ($conversation_id > 0)
                        $sql_extra .= ' AND `item`.`parent` = '.intval($conversation_id);
 
-               $r = q("SELECT `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
+               $r = q("SELECT STRAIGHT_JOIN `item`.*, `item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
                        `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`rel`,
                        `contact`.`network`, `contact`.`thumb`, `contact`.`dfrn-id`, `contact`.`self`,
                        `contact`.`id` AS `cid`, `contact`.`uid` AS `contact-uid`