Ticket #1037 (closed 改善提案: 修正済)

Opened 10 years ago

Last modified 10 years ago

受注管理の検索条件「購入商品」の検索速度が非常に遅い

Reported by: Seasoft Owned by: nanasess
Priority: Milestone: EC-CUBE2.11.1
Component: 管理画面 Version: 2.11.0 β
Keywords: Cc:
修正済み: yes

Description

特に受注明細数が多いサイトで顕著。タイムアウトが発生するレベル。

COUNT せずに EXISTS で評価することで、大幅に改善された。

Change History

comment:1 Changed 10 years ago by nanasess

  • Owner changed from somebody to nanasess
  • 修正済み unset
  • Status changed from new to assigned

comment:2 Changed 10 years ago by nanasess

  • 修正済み set

r20789 で修正しました

comment:3 Changed 10 years ago by kajiwara

  • Status changed from assigned to closed
  • Resolution set to 修正済
Note: See TracTickets for help on using tickets.