diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-11-19 17:54:44 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-11-19 17:54:44 +0000 |
| commit | d03d933b737f66e75c45d6b6b381396c8d4fb837 (patch) | |
| tree | 6b99280e41f5dc77f52dac5f32eca356cf945202 /modules | |
| parent | 980637265c51416b57ba2145d7ab459f0c0eed02 (diff) | |
| download | brdo-d03d933b737f66e75c45d6b6b381396c8d4fb837.tar.gz brdo-d03d933b737f66e75c45d6b6b381396c8d4fb837.tar.bz2 | |
- Performance improvement: changed a LEFT JOIN to an INNER JOIN. Patch #157
by Gerhard.
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/statistics.module | 2 | ||||
| -rw-r--r-- | modules/statistics/statistics.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/statistics.module b/modules/statistics.module index 1be70182b..bbeb72cf6 100644 --- a/modules/statistics.module +++ b/modules/statistics.module @@ -359,7 +359,7 @@ function statistics_admin_accesslog_table($type, $id) { } else if ($type == 2) { /* retrieve recent access logs for node $id */ - $sql = "SELECT a.nid, a.url, a.hostname, a.uid, a.timestamp, n.title FROM {accesslog} a LEFT JOIN {node} n ON a.nid = n.nid WHERE a.nid = ". check_query($id); + $sql = "SELECT a.nid, a.url, a.hostname, a.uid, a.timestamp, n.title FROM {accesslog} a INNER JOIN {node} n ON a.nid = n.nid WHERE a.nid = ". check_query($id); } else if ($type == 3) { /* retrieve recent access logs for hostname $id */ diff --git a/modules/statistics/statistics.module b/modules/statistics/statistics.module index 1be70182b..bbeb72cf6 100644 --- a/modules/statistics/statistics.module +++ b/modules/statistics/statistics.module @@ -359,7 +359,7 @@ function statistics_admin_accesslog_table($type, $id) { } else if ($type == 2) { /* retrieve recent access logs for node $id */ - $sql = "SELECT a.nid, a.url, a.hostname, a.uid, a.timestamp, n.title FROM {accesslog} a LEFT JOIN {node} n ON a.nid = n.nid WHERE a.nid = ". check_query($id); + $sql = "SELECT a.nid, a.url, a.hostname, a.uid, a.timestamp, n.title FROM {accesslog} a INNER JOIN {node} n ON a.nid = n.nid WHERE a.nid = ". check_query($id); } else if ($type == 3) { /* retrieve recent access logs for hostname $id */ |