Ticket #1582 (assigned 改善提案) — at Version 3

Opened 14 years ago

Last modified 14 years ago

SC_Query 一致レコードの有無を返す機能を追加 (パフォーマンス改善)

Reported by: Seasoft Owned by: Seasoft
Priority: 中 Milestone: EC-CUBE2.12.0
Component: その他 Version: 2.11.4
Keywords: Cc:
修正済み: yes

Description (last modified by Seasoft) (diff)

DB に対して、EXISTS で問い合わせる。

現在は「SC_Query::count() > 0」で代替する実装が見受けられるが、DB レスポンスが悪い。
(参考: PostgreSQL 9.0.3 / 10万レコード / プライマリキー列での実測で、1.3～2倍程度遅かった)

r21376

Change History

comment:1 Changed 14 years ago by Seasoft

  • Description modified (diff)

comment:2 Changed 14 years ago by Seasoft

  • Owner changed from somebody to Seasoft
  • Status changed from new to assigned

comment:3 Changed 14 years ago by Seasoft

  • Description modified (diff)
Note: See TracTickets for help on using tickets.