Defect #1441

SQL slowdowns on Shop > Orders

Added by Bubloz Ivan 8 months ago. Updated about 6 hours ago.

Status:ClosedStart date:09/27/2017
Priority:NormalDue date:
Assignee:Van Hoecke Hélène % Done:

100%

Category:SHOP
Target version:4.5.0
Affected version:4.4.4

Description

On the page "My commands" (Frontend) the data loading is very slow.
The problem was found in "sdiBasket" class.
To fix this bug we have extended the class with a new optional "smartviewmode" property (set to false by default).

Sample call of the "SmartView" mode

$basket = new SdiBasket ();
$basket-> Smartviewmode = true;
$basket-LoadOrder ($item-> ID);

This mode ignores setting properties that are not used in this view.

History

#1 Updated by Bubloz Ivan 8 months ago

  • Status changed from Affected to Resolved
  • Assignee changed from Bubloz Ivan to Technical Committee

Revision r10250

Hello,
I am the new developper by ASIT VD.
It is my firt commit, can you please check it ?
Many Thanks.
Best regards.

#2 Updated by Bubloz Ivan 8 months ago

  • Subject changed from SQL slowdowns to SQL slowdowns on Shop > Orders

#3 Updated by Blatti Yves 7 months ago

  • Assignee changed from Technical Committee to Bubloz Ivan

OK for TC

#4 Updated by Bubloz Ivan 7 months ago

  • Status changed from Resolved to To merge

#5 Updated by Blatti Yves 3 months ago

  • % Done changed from 0 to 100

#6 Updated by Blatti Yves 3 months ago

  • Assignee changed from Bubloz Ivan to Van Hoecke Hélène

#7 Updated by Van Hoecke Hélène about 6 hours ago

  • Status changed from To merge to Closed

Also available in: Atom PDF