It looks like the Item pricing screen has a bug. When you enter an item number an search, there seems to be a cursor that is looping through the entire item price table and then finding a specific record. With a large item price table, this seems to result in long wait times for item price result to come back. Below is the cursor picked up in SQL trace.
Has anyone run into this and reported it?
It looks like the Item pricing screen has a bug. When you enter an item number an search, there seems to be a cursor that is looping through the entire item price table and then finding a specific record. With a large item price table, this seems to result in long wait times for item price result to come back. Below is the cursor picked up in SQL trace.
declare @p1 int
set @p1=180150049
declare @p3 int
set @p3=2
declare @p4 int
set @p4=1
declare @p5 int
set @p5=-1
exec sp_cursoropen @p1 output,N'select "CURRENCY","ITEMNO","PRICELIST","AUDTDATE","AUDTTIME","AUDTUSER","AUDTORG","DESC","PRICEDECS","MARKUPCOST","MARKUPUNIT","MARKUPCONV","PRICETYPE","PRICEFMT","PRCNTLVL1","PRCNTLVL2","PRCNTLVL3","PRCNTLVL4","PRCNTLVL5","PRICEBASE","PRICEQTY1","PRICEQTY2","PRICEQTY3","PRICEQTY4","PRICEQTY5","MARKUP","LASTMKPDT","PREVMKPCST","LASTEXCHDT","PREVEXCHRT","ROUNDMETHD","ROUNDAMT","AMOUNTLVL1","AMOUNTLVL2","AMOUNTLVL3","AMOUNTLVL4","AMOUNTLVL5","PRICEBY","MRKUPWUNIT","PRICEWGHT1","PRICEWGHT2","PRICEWGHT3","PRICEWGHT4","PRICEWGHT5","CPRICETYPE","CCHECK","CCHECKBASE","CBASE","DEFBUNIT","DEFBWUNIT","DEFSUNIT","DEFSWUNIT","BPRICETYPE","BDEFUSING","BLOCATION","BBASE","BPERCENT","BAMOUNT","BRATETYPE","BRATEDATE","BEXCHRATE","BRATEOP","BRATEOVRRD","SPRICETYPE","SDEFUSING","SLOCATION","SBASE","SPERCENT","SAMOUNT","SRATETYPE","SRATEDATE","SEXCHRATE","SRATEOP","SRATEOVRRD","PRICESTART","PRICEEND" from "ICPRIC" with (index(ICPRIC_KEY_0) /*,updlock*/) order by "CURRENCY","ITEMNO","PRICELIST"',@p3 output,@p4 output,@p5 output
select @p1, @p3, @p4, @p5
Has anyone run into this and reported it?
