settings pages low speed

[brunello]

hi everyone,
please could you suggest me where find solutions to this.
i'm installed template monster on zencart wesite, and look was very pretty good, for user website working fine and no general issue.
so, only during admin session, loading items, navigate inside general settings and so on, low speed is a disaster.
sometimes 5/6 sec to loading pages, adn sometimes is very hard to load items.
support said me there' not issue during call to webserver.
i think the reason colud be during call to db, reply and things like this.
now db is empty and pics are between 90 and 150 kb.
any advice?
thanks

[lat9]

hi everyone,
please could you suggest me where find solutions to this.
i'm installed template monster on zencart wesite, and look was very pretty good, for user website working fine and no general issue.
so, only during admin session, loading items, navigate inside general settings and so on, low speed is a disaster.
sometimes 5/6 sec to loading pages, adn sometimes is very hard to load items.
support said me there' not issue during call to webserver.
i think the reason colud be during call to db, reply and things like this.
now db is empty and pics are between 90 and 150 kb.
any advice?
thanks

FWIW, those "Template Monster" templates can be (a) very intrusive in their carving up of Zen Cart core files and (b) very database intensive.

Most of them look "very pretty", but you'll need to make a decision as to the site's prettiness vs. the site's ability to easily sell products.

I'll recommend that you take a look at the ZCA Bootstrap template instead: https://www.zen-cart.com/downloads.php?do=file&id=2191

[carlwhat]

i prefer barolo...

i'm going to respectively disagree on this one. while what @lat9 says may be true, @brunello is talking about the admin experience, not the user experience.

even if the template carved up the zen-cart core files, that would be on the user side. now on v157, there has been a lot of consolidating of functions, so that might come into play. but again, i'm suspicious...

a 5-6 second delay on the admin side sounds like something is waiting for a return call from outside the zc ecosphere. or potentially an index is missing... or something else...

if it is a db problem, one could try enabling the slow mysql log, although i do remember some issue with that not being properly set. but that is potentially where i would start as opposed to ripping out the whole template.

best.

[swguy]

Can you easily deploy a vanilla build of Zen Cart and see how the admin responds when no modifications have been made? This would just help you isolate the problem more. You'd want to use the same database settings in your configure.php files.

[brunello]

at now mysql support send me a quick reply on ticket with follow:
change storage engine type from MyIsam to Innodb, in order to reduce .... and so on.
after changing, front end have a very high speeed, and also on smartphone is more fast.
back end is too slow also when digit admin page on browser.
now i'm waiting forn next reply support ticket.
any idea?

[mc12345678]

As far as the previous suggestion of an alternate admin, generally it is possible to install or load an additional admin directory that has just the core files. If the problem is only in or only to test the configuration menu, there should be no issue.

[brunello]

i'll do this.
this evening i'll do this.
let me do this,
thanks
bruno

[barco57]

Is it all pages in the admin that are slow or is it just some pages?

[brunello]

Hi everyone,
sorry for delay but sql support give me response in order to understand issue.
thanks @barco57 for your reply. low speed is in all pages, also when you log in on admin page from browser. about 15/20 sec to log in.

mysql support give me follow response.

php version installed on yuor db is old, and this could generated low speed during transfer
in fact PHP is 7.4.


zencart is not a default installation, graphic template was installed and work was so deeply.
could php 7.4 generated all this?
seem that upgrade to 8.X need a couple of months, website is an ITA version, and package was not fully translated, need to re type some words.
thanks to everyone