madeon (madeon) wrote in changelog,
madeon
madeon
changelog

[livejournal] r23517: LJSUP-14739: remove "USE INDEX (rlogtime...

Committer: sbelyaev
LJSUP-14739: remove "USE INDEX (rlogtime)" from sql query to log2 table
U   trunk/cgi-bin/LJ/Event.pm
Modified: trunk/cgi-bin/LJ/Event.pm
===================================================================
--- trunk/cgi-bin/LJ/Event.pm	2013-01-09 11:00:32 UTC (rev 23516)
+++ trunk/cgi-bin/LJ/Event.pm	2013-01-09 11:42:45 UTC (rev 23517)
@@ -694,7 +694,6 @@
                     userid, subid, is_dirty, journalid, etypeid,
                     arg1, arg2, ntypeid, createtime, expiretime, flags
                 FROM subs
-                USE INDEX(PRIMARY)
                 WHERE etypeid=? AND journalid=0 $and_enabled
                     AND userid IN ($jidlist)
             });

Tags: livejournal, madeon, pm, sbelyaev
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments