From 1d5ab0d38219163e07cc0923d30349e3bc82b9d7 Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Fri, 26 Feb 2010 18:19:58 +0100 Subject: add LIMITs to (maybe) speedup queries Signed-off-by: Florian Pritz --- system/application/controllers/file.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'system/application/controllers/file.php') diff --git a/system/application/controllers/file.php b/system/application/controllers/file.php index 96165eb55..ac8f15452 100644 --- a/system/application/controllers/file.php +++ b/system/application/controllers/file.php @@ -218,7 +218,7 @@ class File extends Controller { unlink($file); $this->db->query('DELETE FROM files WHERE hash = ?', array($row['hash'])); } else { - $this->db->query('DELETE FROM files WHERE id = ?', array($row['id'])); + $this->db->query('DELETE FROM files WHERE id = ? LIMIT 1', array($row['id'])); } } } -- cgit v1.2.3-24-g4f1b