Forums / Bug Reports / [Done v157a] Slow admin home page load due to attribute details

[Done v157a] Slow admin home page load due to attribute details

Views: 1,916

Results 1 to 4 of 4
27 Jul 2020, 4:37 PM
#1
ryk avatar

ryk

Totally Zenned

Join Date:
Oct 2004
Location:
Southport, UK
Posts:
3,644
Plugin Contributions:
6

[Done v157a] Slow admin home page load due to attribute details

On upgrading a client's site to ZC157, admin home page very slow to load - about 9 seconds. So we uploaded a vanilla 157 and got the same results. Page initially loads OK but there is a long pause at the point of loading the new orders widget. Investigation suggested that it was related to looking up attribute data on each product.

With
lines 48 - 56 commented out in RecentOrdersDashboardWidget.php , admin page load has reduced to a much more acceptable 1.34 seconds.

Development Manager @ JSWeb Ltd - suppliers of Applepay/Googlepay for Zencart
20 years with Zencart !

27 Jul 2020, 4:46 PM
#2
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,725
Plugin Contributions:
56

Re: [Done v157a] Slow admin home page load due to attribute details

Thanks for reporting this finding and doing the analysis.

Perhaps the dashboard widget should say "Open the order to see the attribute details" and not do this additional query?

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

27 Jul 2020, 4:58 PM
#3
ryk avatar

ryk

Totally Zenned

Join Date:
Oct 2004
Location:
Southport, UK
Posts:
3,644
Plugin Contributions:
6

Re: [Done v157a] Slow admin home page load due to attribute details

That makes perfect sense to me - there's only so much information a storeowner can absorb from the one page, and the admin home page really is an overview.

Development Manager @ JSWeb Ltd - suppliers of Applepay/Googlepay for Zencart
20 years with Zencart !

27 Jul 2020, 5:20 PM
#4
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,725
Plugin Contributions:
56

Re: [Done v157a] Slow admin home page load due to attribute details

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.