summaryrefslogtreecommitdiff
path: root/index.php
diff options
context:
space:
mode:
Diffstat (limited to 'index.php')
-rw-r--r--index.php9
1 files changed, 0 insertions, 9 deletions
diff --git a/index.php b/index.php
index 041fd7ef5..a893d4753 100644
--- a/index.php
+++ b/index.php
@@ -14,15 +14,6 @@ $date = ($date) ? $date : time();
### Perform query:
$result = db_query("SELECT stories.*, users.userid, COUNT(comments.sid) AS comments FROM stories LEFT JOIN comments ON stories.id = comments.sid LEFT JOIN users ON stories.author = users.id WHERE stories.status = 2 AND stories.timestamp <= $date GROUP BY stories.id ORDER BY stories.timestamp DESC LIMIT $number");
- // Note on performance:
- // we use a LEFT JOIN to retrieve the number of comments associated
- // with each story. By retrieving this data now (outside the while-
- // loop), we elimate a *lot* of individual queries that would other-
- // wise be required (inside the while-loop). If there is no matching
- // record for the right table in the ON-part of the LEFT JOIN, a row
- // with all columns set to NULL is used for the right table. This is
- // required, as not every story has a counterpart in the comments
- // table (at a given time).
### Display stories:
$theme->header();