diff options
| author | Matthieu Napoli <matthieu@mnapoli.fr> | 2015-03-06 00:20:29 +0300 |
|---|---|---|
| committer | Matthieu Napoli <matthieu@mnapoli.fr> | 2015-03-06 00:20:29 +0300 |
| commit | 60562b83c5f2c57bb8835f112e9a637408a1082f (patch) | |
| tree | d56028d3d234fe8edffb8b28e512e7b1df585e43 /core/Tracker/Model.php | |
| parent | b1b6009cf7794be20469b4c7ec45892d6ec14b96 (diff) | |
#7087 Query optimization
Diffstat (limited to 'core/Tracker/Model.php')
| -rw-r--r-- | core/Tracker/Model.php | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/core/Tracker/Model.php b/core/Tracker/Model.php index 0911ca2f3a..bb4fc1075a 100644 --- a/core/Tracker/Model.php +++ b/core/Tracker/Model.php @@ -399,13 +399,11 @@ class Model */ public function isSiteEmpty($siteId) { - $sql = "SELECT COUNT(*) - FROM " . Common::prefixTable('log_visit') . " - WHERE idsite = ?"; + $sql = sprintf('SELECT idsite FROM %s WHERE idsite = ? limit 1', Common::prefixTable('log_visit')); - $count = \Piwik\Db::fetchOne($sql, array($siteId)); + $result = \Piwik\Db::fetchOne($sql, array($siteId)); - return $count == 0; + return $result == null; } private function visitFieldsToQuery($valuesToUpdate) |