Changeset 1742

Timestamp:

05/26/10 15:29:44 (3 years ago)

Author:

nick_ramsay

Message:

[Branch 1.3] Reduced the SQL result set for child comments by three columns. Checking the comment tree for each parent comment is quite time consuming so we have to shave off any unnecessary baggage.

File:

• branches/1.3/libs/Comment.php (modified) (1 diff)

branches/1.3/libs/Comment.php

@@ -146 +146 @@
         function readAllChildren($h, $parent)
         {
-                $sql = "SELECT * FROM " . TABLE_COMMENTS . " WHERE comment_parent = %d AND comment_status = %s ORDER BY comment_date";
+                $fields = "comment_id, comment_post_id, comment_user_id, comment_parent, comment_date, comment_status, comment_content, comment_votes_up, comment_votes_down, comment_subscribe";
+                
+                $sql = "SELECT " . $fields . " FROM " . TABLE_COMMENTS . " WHERE comment_parent = %d AND comment_status = %s ORDER BY comment_date";
                 $query = $h->db->prepare($sql, $parent, 'approved');