0037520: Performance problem in remote mode when filter by best sellers category

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #37520		[ All Revisions ] [ Back to Issue ]
Summary	0037520: Performance problem in remote mode when filter by best sellers category

Revision	2017-12-21 16:39 by Sandrahuguet
Steps To Reproduce	In a hgvol environment -Enable all high volumes preference -Log in the WebPOS -Tap on Search -Select "Best sellers" in product category combo Slow part: add(new HQLProperty("case when product.isGeneric is false then " + "(case when pli.bestseller = 'Y' then true else false end) " + "when (product.isGeneric is true and exists(select 1 " + "from Product p3 left join p3.oBRETCOProlProductList as pli3, " + "PricingProductPrice ppp3 where p3.genericProduct.id = product.id and " + "p3 = ppp3.product and ppp3.priceListVersion.id = :priceListVersionId " + "and pli3.obretcoProductlist.id = :productListId and pli3.bestseller = true)) " + "then true else false end", "bestseller"));

Revision	2017-12-20 10:01 by Sandrahuguet
Steps To Reproduce	-Enable all high volumes preference -Log in the WebPOS -Tap om Search -Select "Best sellers" in product category combo Slow part: add(new HQLProperty("case when product.isGeneric is false then " + "(case when pli.bestseller = 'Y' then true else false end) " + "when (product.isGeneric is true and exists(select 1 " + "from Product p3 left join p3.oBRETCOProlProductList as pli3, " + "PricingProductPrice ppp3 where p3.genericProduct.id = product.id and " + "p3 = ppp3.product and ppp3.priceListVersion.id = :priceListVersionId " + "and pli3.obretcoProductlist.id = :productListId and pli3.bestseller = true)) " + "then true else false end", "bestseller"));

Revision	2017-12-20 10:00 by Sandrahuguet
Steps To Reproduce	-Enable all high volumes preference -Log in the WebPOS -Tap om Search -Select "Best sellers" in product category combo Slowest part: add(new HQLProperty("case when product.isGeneric is false then " + "(case when pli.bestseller = 'Y' then true else false end) " + "when (product.isGeneric is true and exists(select 1 " + "from Product p3 left join p3.oBRETCOProlProductList as pli3, " + "PricingProductPrice ppp3 where p3.genericProduct.id = product.id and " + "p3 = ppp3.product and ppp3.priceListVersion.id = :priceListVersionId " + "and pli3.obretcoProductlist.id = :productListId and pli3.bestseller = true)) " + "then true else false end", "bestseller"));