details: /erp/devel/pi/rev/efdbe4e29619 changeset: 6476:efdbe4e29619 user: Stefan Hühner <stefan.huehner <at> openbravo.com> date: Tue Feb 23 18:42:24 2010 +0100 summary: Fixed 12420: Optimize whereclause to make grid view of product price tab faster with many products & prices
diffstat: src-db/database/sourcedata/AD_TAB.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diffs (12 lines): diff -r 35dc05a84c8b -r efdbe4e29619 src-db/database/sourcedata/AD_TAB.xml --- a/src-db/database/sourcedata/AD_TAB.xml Tue Feb 23 17:50:44 2010 +0100 +++ b/src-db/database/sourcedata/AD_TAB.xml Tue Feb 23 18:42:24 2010 +0100 @@ -1710,7 +1710,7 @@ <!--192--> <ISREADONLY><![CDATA[N]]></ISREADONLY> <!--192--> <AD_COLUMN_ID><![CDATA[2760]]></AD_COLUMN_ID> <!--192--> <HASTREE><![CDATA[N]]></HASTREE> -<!--192--> <WHERECLAUSE><![CDATA[(SELECT isActive FROM M_Product WHERE M_Product.M_Product_Id = M_ProductPrice.M_Product_Id ) = 'Y']]></WHERECLAUSE> +<!--192--> <WHERECLAUSE><![CDATA[EXISTS (SELECT 1 FROM M_Product WHERE M_Product.M_Product_Id = M_ProductPrice.M_Product_Id AND M_Product.IsActive = 'Y')]]></WHERECLAUSE> <!--192--> <PROCESSING><![CDATA[N]]></PROCESSING> <!--192--> <ISSORTTAB><![CDATA[N]]></ISSORTTAB> <!--192--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
