summaryrefslogtreecommitdiffstats
path: root/system/application/models/file_mod.php
diff options
context:
space:
mode:
authorFlorian Pritz <bluewind@xssn.at>2010-02-26 18:19:58 +0100
committerFlorian Pritz <bluewind@xssn.at>2010-02-26 18:19:58 +0100
commit1d5ab0d38219163e07cc0923d30349e3bc82b9d7 (patch)
tree35af55c294cd1d651f539dc566a319d909ace2de /system/application/models/file_mod.php
parentd3e4293d43ca8bd63e6fd2a10d6363485fe2eb6c (diff)
add LIMITs to (maybe) speedup queries
Signed-off-by: Florian Pritz <bluewind@xssn.at>
Diffstat (limited to 'system/application/models/file_mod.php')
-rw-r--r--system/application/models/file_mod.php9
1 files changed, 6 insertions, 3 deletions
diff --git a/system/application/models/file_mod.php b/system/application/models/file_mod.php
index 23c3002af..769273f2f 100644
--- a/system/application/models/file_mod.php
+++ b/system/application/models/file_mod.php
@@ -30,7 +30,8 @@ class File_mod extends Model {
$sql = '
SELECT id
FROM `files`
- WHERE `id` = ?';
+ WHERE `id` = ?
+ LIMIT 1';
$query = $this->db->query($sql, array($id));
if ($query->num_rows() == 1) {
@@ -45,7 +46,8 @@ class File_mod extends Model {
$sql = '
SELECT hash,filename
FROM `files`
- WHERE `id` = ?';
+ WHERE `id` = ?
+ LIMIT 1';
$query = $this->db->query($sql, array($id));
if ($query->num_rows() == 1) {
@@ -74,7 +76,8 @@ class File_mod extends Model {
$sql = '
SELECT id
FROM `files`
- WHERE `hash` = ?';
+ WHERE `hash` = ?
+ LIMIT 1';
$query = $this->db->query($sql, array($hash));
if ($query->num_rows() == 0) {