New function to detect heavily used indexes

[friendica.git] / include / session.php

diff --git a/include/session.php b/include/session.php
index 763b05f48166babb5d8eaf28976a22de68e8f587..31024060f3c0c7c1f465a6cee6fde44af8a4c0bf 100644 (file)
--- a/include/session.php
+++ b/include/session.php
@@ -71,14 +71,10 @@ function ref_session_write($id, $data) {
 
        if ($session_exists) {
                $r = q("UPDATE `session`
-                               SET `data` = '%s'
-                               WHERE `data` != '%s' AND `sid` = '%s'",
-                               dbesc($data), dbesc($data), dbesc($id));
-
-               $r = q("UPDATE `session`
-                               SET `expire` = '%s'
-                               WHERE `expire` != '%s' AND `sid` = '%s'",
-                               dbesc($expire), dbesc($expire), dbesc($id));
+                               SET `data` = '%s', `expire` = '%s'
+                               WHERE `sid` = '%s'
+                               AND (`data` != '%s' OR `expire` != '%s')",
+                               dbesc($data), dbesc($expire), dbesc($id), dbesc($data), dbesc($expire));
        } else {
                $r = q("INSERT INTO `session`
                                SET `sid` = '%s', `expire` = '%s', `data` = '%s'",