From f577c125e84bc3a1f30bcc40105788d0547a534a Mon Sep 17 00:00:00 2001 From: Angie Byron Date: Sat, 16 May 2009 15:23:16 +0000 Subject: #196862 by Damien Tournoud, et al: Replace COUNT(*) queries with SELECT 1 ... LIMIT 1 queries when all that's required is a check for whether rows exist. --- modules/php/php.install | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/php/php.install') diff --git a/modules/php/php.install b/modules/php/php.install index 16f67db82..6eaa0ba96 100644 --- a/modules/php/php.install +++ b/modules/php/php.install @@ -10,7 +10,7 @@ * Implementation of hook_install(). */ function php_install() { - $format_exists = db_query("SELECT COUNT(*) FROM {filter_format} WHERE name = 'PHP code'")->fetchField(); + $format_exists = (bool) db_query_range('SELECT 1 FROM {filter_format} WHERE name = :name', array(':name' => 'PHP code'), 0, 1)->fetchField(); // Add a PHP code text format, if it does not exist. Do this only for the // first install (or if the format has been manually deleted) as there is no // reliable method to identify the format in an uninstall hook or in -- cgit v1.2.3