Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18
  1. #11
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    237
    Plugin Contributions
    5

    Default Re: Admin login page loads very slow.

    Here is another instance of 155 admin login pages and all other admin pages being slow to load.
    Production is a new build of ZC155a with the data base migrated from 1.3.9h.

    In production:
    Admin takes 60.57 seconds to log on and takes 60 secs + to load any page in admin eg Profiles 60.25s; Coupon Admin 61.02s; Customer 60.79s
    whereas the response for a customer using the catalog is : view a special produc 0.52s; login screen 3.36s; logging in 0.91s; search on random part number 0.72s

    It is as if something is being called in admin and then times out after 60 seconds.

    There are no ZC error logs entries.
    ZC internal error logging is set to false.

    Environment:
    ZC155a
    Apache 2.4
    Server OS Linux 3.13.0
    PHP 5.5.9-1
    MySQL 5.6.33

  2. #12
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    237
    Plugin Contributions
    5

    Default Re: Admin login page loads very slow.

    Here is an update Monday 3 October 2016 9:04PM AEST (GNT +10). During diagnosis testing both my test installation ( Windows local server) and the Linux production server came alive!

    Production response times are now:
    Admin log on 1.15s; Profiles 1.00s; Coupon Admin 1.31s; Customer 1.93s.

    What external dependencies are there in ZC Admin where it is waiting for a response from an external server or trying to download something?

  3. #13
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,632
    Plugin Contributions
    11

    Default Re: Admin login page loads very slow.

    check the network tab in your browser's developer tools. it will tell you what is getting loaded and where your slowdown is... if it exists.

  4. #14
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    237
    Plugin Contributions
    5

    Default Re: Admin login page loads very slow.

    The network tab only lists the main page sent to the browser and not the server side page includes.

    The issue turned out to be the calls to Zen Cart and OzPost websites that occur in the header, The header is resent for every page and action. Slow response from the called servers resulted in the slowness of the pages. OzPost version check every page can be turned off in the Shipping \ OzPost module itself. The Zen Cart check on every page can be turned off in admin\includes\local\skip_version_check.ini.

    I know what version is being used so there is no need for a check to be made on every page load - once a day would be sufficient.

  5. #15
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: Admin login page loads very slow.

    Quote Originally Posted by OldNGrey View Post
    The issue turned out to be the calls to Zen Cart and OzPost websites that occur in the header, The header is resent for every page and action. Slow response from the called servers resulted in the slowness of the pages.
    I would like to add that the slowness observed will only occur if there is a problem with the ozpost server, and this is quite a rare occurrence.

    Quote Originally Posted by OldNGrey View Post
    OzPost version check every page can be turned off in the Shipping \ OzPost module itself. The Zen Cart check on every page can be turned off in admin\includes\local\skip_version_check.ini.
    Correct, but in both instances, when the servers are functioning normally the time it takes for the requests are really quite small (just a few microseconds), so if anyone is having constant slow page loads the problem is likely to be something other than these version checks.

    Quote Originally Posted by OldNGrey View Post
    I know what version is being used so there is no need for a check to be made on every page load - once a day would be sufficient.
    I do tend to agree with you here, so I'll look into seeing if I can do something to remedy this in the next ozpost update. There are basically two options available.
    1) To store the results in a SESSION file, but this may not be suitable because it would depend on when ZenCart creates/destroys its SESSIONS. (Something I'll need to investigate).
    2) Store the results in a database table - My concern here is that a DB access can actually be slower than a response from the server(s), which is possibly the reason why the ZenCart devs didn't take this approach.

    FWIW, I followed the ZenCart method of version checking for OzPost, which uses the @file($URL) command. I figure that they had good reason (and good success) using this method, the code is simple, quick, and generally reliable. It obviously has a shortcoming if there is a problem with the remote server(s) though. The 'cure' may be worse than the problem.

    Perhaps one of the ZenCart dev's would like to step in with a comment?

    Cheers
    RodG

  6. #16
    Join Date
    Jan 2004
    Posts
    66,362
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Admin login page loads very slow.

    Quote Originally Posted by OldNGrey View Post
    The Zen Cart check on every page can be turned off in admin\includes\local\skip_version_check.ini.
    a. It's not checked on every page
    b. You can also turn it off more easily from within your Admin by going to Configuration->My Store-> Show if version update available


    You didn't state where your webserver is located. I wonder if this issue is simply a latency delay with DNS lookups. And if that's the case, certainly turning off the automatic check (which in turn replaces it with a manual check which you can do by clicking the button that appears) is the simplest and ideal fix.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #17
    Join Date
    Apr 2008
    Location
    Athens
    Posts
    84
    Plugin Contributions
    0

    Default Re: Admin login page loads very slow.

    I made a new database and import old database data and now its working fast. So the solution is to make a new database.

  8. #18
    Join Date
    Apr 2008
    Location
    Athens
    Posts
    84
    Plugin Contributions
    0

    Default Re: Admin login page loads very slow.

    Quote Originally Posted by soki View Post
    I made a new database and import old database data and now its working fast. So the solution is to make a new database.
    sorry it was a bot attack finally

    I edit the .htaccess file and block the bot and now admin load fasts

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v150 Images - slow page loads
    By saftek in forum General Questions
    Replies: 6
    Last Post: 21 Feb 2014, 05:05 AM
  2. v150 Admin suddenly became very slow on every page
    By Ashely in forum General Questions
    Replies: 2
    Last Post: 23 Sep 2012, 03:45 AM
  3. Admin page loads are very slow
    By AndyII in forum General Questions
    Replies: 7
    Last Post: 15 Feb 2009, 04:12 PM
  4. Storefront loads fast; admin loads very slow
    By TheHYPO in forum General Questions
    Replies: 4
    Last Post: 28 Sep 2008, 04:19 AM
  5. Very Slow Page Loads... ZC 1.3.0.2
    By Picci in forum General Questions
    Replies: 14
    Last Post: 7 Feb 2007, 05:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR