Changeset 14075

Timestamp:

07/25/08 18:13:01 (5 years ago)

Author:

henrylyne

Message:

Optimize querys against poll2 table.

Files:

• trunk/cgi-bin/LJ/Poll.pm (modified) (3 diffs)

trunk/cgi-bin/LJ/Poll.pm

@@ -550 +550 @@
             $row = $u->selectrow_hashref("SELECT pollid, journalid, ditemid, " .
                                          "posterid, whovote, whoview, name, status " .
-                                         "FROM poll2 WHERE pollid=?", undef, $self->pollid);
+                                         "FROM poll2 WHERE pollid=? " .
+                                         "AND journalid=?", undef, $self->pollid, $journalid);
             die $u->errstr if $u->err;
         } else {
@@ -593 +594 @@
     if ($u->polls_clustered) {
         # poll stored on user cluster
-        $u->do("UPDATE poll2 SET status='X' where pollid=? ",
-               undef, $self->pollid);
+        $u->do("UPDATE poll2 SET status='X' where pollid=? AND journalid=?",
+               undef, $self->pollid, $self->journalid);
         die $u->errstr if $u->err;
     } else {
@@ -620 +621 @@
     if ($u->polls_clustered) {
         # poll stored on user cluster
-        $u->do("UPDATE poll2 SET status='' where pollid=? ",
-               undef, $self->pollid);
+        $u->do("UPDATE poll2 SET status='' where pollid=? AND journalid=?",
+               undef, $self->pollid, $self->journalid);
         die $u->errstr if $u->err;
     } else {