Project

General

Profile

Enhancement(機能追加・改善) #401

Speed up filtering member_config SQL in login process (ログイン処理における、 member_config を絞り込む SQL の速度を改善する)

Added by Eitarow Fukamachi over 10 years ago. Updated over 10 years ago.

Status:
Fixed(完了)
Priority:
Normal(通常)
Target version:
Start date:
2009-12-30
Due date:
% Done:

100%


Description

ログイン時に発行される以下のクエリが遅いため改善する。

SELECT m.id AS m__id, m.member_id AS m__member_id, m.name AS m__name, m.value AS m__value, m.value_datetime AS m__value_datetime, m.created_at AS m__created_at, m.updated_at AS m__updated_at FROM member_config m WHERE m.name = 'S' AND m.value = 'S'

Associated revisions

Revision 985b63b7 (diff)
Added by Eitarow Fukamachi over 10 years ago

added new hash field (name_value_hash) to member_config for searching more speedy (refs #401)

Revision b9c5f6eb (diff)
Added by Kousuke Ebihara over 10 years ago

fixed upgrade-from-2 for new column for member_config (refs #401)

History

#1 Updated by Eitarow Fukamachi over 10 years ago

  • Tracker changed from Bug(バグ) to Enhancement(機能追加・改善)

#2 Updated by Eitarow Fukamachi over 10 years ago

  • Status changed from New(新規) to Pending Fixing(修正待ち)
  • Target version set to OpenPNE 3.3.2
  • % Done changed from 0 to 90

修正しました。

#3 Updated by Kousuke Ebihara over 10 years ago

  • Status changed from Pending Fixing(修正待ち) to Pending Review(レビュー待ち)
  • % Done changed from 90 to 50

#4 Updated by Kousuke Ebihara over 10 years ago

  • Subject changed from ログイン処理のmember_configに対するSQLクエリが遅い to Speed up filtering member_config SQL in login process (ログイン処理の member_config に対する SQL の速度を改善する)
  • Status changed from Pending Review(レビュー待ち) to Fixed(完了)
  • % Done changed from 50 to 100

#5 Updated by Kousuke Ebihara over 10 years ago

  • Subject changed from Speed up filtering member_config SQL in login process (ログイン処理の member_config に対する SQL の速度を改善する) to Speed up filtering member_config SQL in login process (ログイン処理における member_config の絞り込みの SQL の速度を改善する)

#6 Updated by Kousuke Ebihara over 10 years ago

  • Subject changed from Speed up filtering member_config SQL in login process (ログイン処理における member_config の絞り込みの SQL の速度を改善する) to Speed up filtering member_config SQL in login process (ログイン処理における、 member_config を絞り込む SQL の速度を改善する)

Also available in: Atom PDF