Slow loading orders

**lat9** · 29 Apr 2022, 02:25 PM

Originally Posted by Nick1973

Just done that, after no joy repairing the database and they load like lightning. I was just looking at it here when you replied Cindy https://docs.zen-cart.com/user/speed/admin_slow/

Noting, too, that there's a change in the zc158 branch that enables these settings to be 'controlled' without core-file-carving:

Code:

// To override these values, create a file in admin/includes/extra_configures
if (!isset($quick_view_popover_enabled)) $quick_view_popover_enabled = false;
if (!isset($includeAttributesInProductDetailRows)) $includeAttributesInProductDetailRows = true;

I'll suggest making the modifications to the zc157 version to include the above and then create /admin/includes/extra_configures/site_specific_overrides.php that contains

Code:

<?php
$quick_view_popover_enabled = false;
$includeAttributesInProductDetailRows = false;

That'll save you a world-of-hurt when upgrading to zc158. As always, comment the heck out of the changes so that you (or your successor) have a clue as to what was done!

**Nick1973** · 29 Apr 2022, 02:35 PM

Originally Posted by lat9

zc157a introduced a popover functionality to the orders' listing to quickly view the products that are in a specific order. If the associated site has a bunch of attributed-products, that can significantly slow down the rendering of the orders' listing display.

You can change the behavior by editing the core-file /admin/orders.php. Find (close to the top of the file):

Code:

$quick_view_popover_enabled = false;
$includeAttributesInProductDetailRows = true;

and change to

Code:

$quick_view_popover_enabled = false;
$includeAttributesInProductDetailRows = false;

It was actually this line in admin/orders.php

PHP Code:


$includeAttributesInProductDetailRows = true;

Changed it to

PHP Code:


$includeAttributesInProductDetailRows = false;

And the speed of the orders loading immediately increased.

**Nick1973** · 29 Apr 2022, 02:37 PM

Originally Posted by lat9

Noting, too, that there's a change in the zc158 branch that enables these settings to be 'controlled' without core-file-carving:

Code:

// To override these values, create a file in admin/includes/extra_configures
if (!isset($quick_view_popover_enabled)) $quick_view_popover_enabled = false;
if (!isset($includeAttributesInProductDetailRows)) $includeAttributesInProductDetailRows = true;

I'll suggest making the modifications to the zc157 version to include the above and then create /admin/includes/extra_configures/site_specific_overrides.php that contains

Code:

<?php
$quick_view_popover_enabled = false;
$includeAttributesInProductDetailRows = false;

That'll save you a world-of-hurt when upgrading to zc158. As always, comment the heck out of the changes so that you (or your successor) have a clue as to what was done!

Oh and as always, Thank You Cindy :-)