Changeset 20789


Ignore:
Timestamp:
2011/03/29 12:27:24 (11 years ago)
Author:
nanasess
bzr:base-revision:
svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_11-dev:20788
bzr:committer:
Kentaro Ohkouchi <ohkouchi@loop-az.jp>
bzr:file-ids:

data/class/pages/admin/order/LC_Page_Admin_Order.php 15584@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Forder%2FLC_Page_Admin_Order.php
bzr:mapping-version:
v4
bzr:merge:

ohkouchi@loop-az.jp-20110329032534-1fdmo53sdup6jwrj
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
ohkouchi@loop-az.jp-20110329032721-gue3da46umbm44jm
bzr:revno:
3501
bzr:revprop:branch-nick:
branches/version-2_11-dev
bzr:root:
branches/version-2_11-dev
bzr:text-revisions:

data/class/pages/admin/order/LC_Page_Admin_Order.php ohkouchi@loop-az.jp-20110329032534-1fdmo53sdup6jwrj
bzr:timestamp:
2011-03-29 12:27:21.148999929 +0900
bzr:user-agent:
bzr2.2.1+bzr-svn1.0.4
svn:original-date:
2011-03-29T03:27:21.149000Z
Message:

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

  • EXISTS を使用するよう修正
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_11-dev/data/class/pages/admin/order/LC_Page_Admin_Order.php

    r20764 r20789  
    269269 
    270270        case 'search_product_name': 
    271             $where .= " AND (SELECT COUNT(*) FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name LIKE ?) > 0"; 
     271            $where .= " AND EXISTS (SELECT 1 FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name LIKE ?)"; 
    272272            $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 
    273273            break; 
Note: See TracChangeset for help on using the changeset viewer.