Slow loading orders

[Nick1973]

My orders are loading slowly in the admin in 1.5.7d since upgrading

I've tested on a live install and a virgin install, and also by importing minimal orders into the database. Has anybody else had an issue with slow loading orders through the admin in 1.5.7d?

There aren't any error logs either

[mprough]

Try running repair on the database in PHPMyAdmin or similar database tool.

~Melanie

[balihr]

I've tested on a live install and a virgin install, and also by importing minimal orders into the database. Has anybody else had an issue with slow loading orders through the admin in 1.5.7d?

Can you confirm the import was done properly, meaning there are no missing entries? For example, orders table has order_id 12345, and orders_products (or orders_status_history) doesn't have that order_id.
This is something I found interesting with RecentOrdersDashboardWidget.php causing the index page to load extremely slow and it seems to have been caused by partial data in one of the orders tables...

[Nick1973]

Try running repair on the database in PHPMyAdmin or similar database tool.

~Melanie

Well there are around 8 large databases on the hosting account so I am off to back everything up and delete the unnecessary ones. They are old, from previous versions of the website. Then after that, like you say, I'll try running a repair on a spare database so it doesn't cause an issue with the live site if it goes wrong.

[Nick1973]

I have disabled RecentOrdersDashboardWidget.php for now, just running a repair on the database.

[Nick1973]

Can you confirm the import was done properly, meaning there are no missing entries? For example, orders table has order_id 12345, and orders_products (or orders_status_history) doesn't have that order_id.
This is something I found interesting with RecentOrdersDashboardWidget.php causing the index page to load extremely slow and it seems to have been caused by partial data in one of the orders tables...

And the import was done very carefully and correctly, in fact several times to make sure it had actually been done correctly

[lat9]

My orders are loading slowly in the admin in 1.5.7d since upgrading

I've tested on a live install and a virgin install, and also by importing minimal orders into the database. Has anybody else had an issue with slow loading orders through the admin in 1.5.7d?

There aren't any error logs either

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):

$quick_view_popover_enabled = false;
$includeAttributesInProductDetailRows = true;

and change to

$quick_view_popover_enabled = false;
$includeAttributesInProductDetailRows = false;

[swguy]

> This is something I found interesting with RecentOrdersDashboardWidget.php causing the index page to load extremely slow and it seems to have been caused by partial data in one of the orders tables...

@balihr would you please provide an example of something that induces this? I'd like to add this check to the audit tool.

[Nick1973]

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):

$quick_view_popover_enabled = false;
$includeAttributesInProductDetailRows = true;

and change to

$quick_view_popover_enabled = false;
$includeAttributesInProductDetailRows = false;

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/

[balihr]

> This is something I found interesting with RecentOrdersDashboardWidget.php causing the index page to load extremely slow and it seems to have been caused by partial data in one of the orders tables...

@balihr would you please provide an example of something that induces this? I'd like to add this check to the audit tool.

I don't have all the details just yet because it's still WIP. The version upgrade wasn't done by me, but it's a dev site with an upgraded DB and the orders table has only a few hundred of the latest orders, whilst all other orders_ tables have a lot more records (the live site has over 100k orders in the DB). I have no idea how or why the orders table was chopped, but both the index page and orders page are extremely slow to load. I changed RecentOrdersDashboardWidget.php from

$sql = "SELECT o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id,
                   o.date_purchased as date_purchased, o.currency, o.currency_value,
                   ot.class, ot.text as order_total, ot.value as order_value
            FROM " . TABLE_ORDERS . " o
            LEFT JOIN " . TABLE_ORDERS_TOTAL . " ot ON (o.orders_id = ot.orders_id AND class = 'ot_total')
            ORDER BY orders_id DESC";

to

$sql = "SELECT o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id,
                   o.date_purchased as date_purchased, o.currency, o.currency_value,
                   ot.class, ot.text as order_total, ot.value as order_value
            FROM " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot
             WHERE o.orders_id = ot.orders_id AND ot.class = 'ot_total'
            ORDER BY orders_id DESC";

and it worked like a charm.
Didn't investigate any further because I asked for clarification why the orders table was butchered and am awaiting info.