ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 7611


Ignore:
Timestamp:
Jun 18, 2008, 6:43:13 PM (13 years ago)
Author:
ebihara
Message:

#2694:p_h_home_c_diary_friend_list4c_member_id()とp_h_diary_list_friend_h_diary_list_friend4c_member_id()が適切にインデックスを使っていなかったのを修正

File:
1 edited

Legend:

Unmodified
Added
Removed

  • OpenPNE/branches/stable-2.12.x/webapp/lib/db/diary.php

    r7390 r7611  
    421421    $ids = implode(',', array_map('intval', $friends));
    422422
    423     $hint = db_mysql_hint('USE INDEX (c_member_id_r_datetime_public_flag)');
     423    $hint = db_mysql_hint('USE INDEX (r_datetime_c_member_id, r_datetime)');
    424424    $sql = 'SELECT * FROM c_diary' . $hint .
    425425            ' WHERE c_member_id IN (' . $ids . ')' .
    … …  
    509509    $ids = implode(',', array_map('intval', $friends));
    510510
    511     $hint = db_mysql_hint('USE INDEX (c_member_id_r_datetime_public_flag)');
     511    $hint = db_mysql_hint('USE INDEX (r_datetime_c_member_id, r_datetime)');
    512512    $sql = 'SELECT * FROM c_diary' . $hint .
    513513            ' WHERE c_member_id IN (' . $ids . ')' .
Note: See TracChangeset for help on using the changeset viewer.