Changeset 20789

Timestamp:

2011/03/29 12:27:24 (12 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:

• branches/version-2_11-dev/data/class/pages/admin/order/LC_Page_Admin_Order.php (modified) (1 diff)

branches/version-2_11-dev/data/class/pages/admin/order/LC_Page_Admin_Order.php

@@ -269 +269 @@
 
         case 'search_product_name':
-            $where .= " AND (SELECT COUNT(*) FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name LIKE ?) > 0";
+            $where .= " AND EXISTS (SELECT 1 FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name LIKE ?)";
             $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key));
             break;