Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2004
    Posts
    113
    Plugin Contributions
    0

    Default Slow store - sometimes(!)

    My new install runs quite slow at times, and I'm suspecting something at the ISP is causing it... like PHP or SQL server overload. Now at 8pm I can change pages in the store real fast, like 2-3 seconds... this afternoon it was taking 20-30+. I experienced a problem yesterday afternoon too.

    GZIP is ON, no SSL (yet), and SQL_CACHE_METHOD is set to 'none'. Have I missed anything?

    In an older version I seem to remember a message in the footer that shows load time ... is there a place I can turn that ON for now? Is there a way I can analyze more deeply what's going on (PHP vs SQL response)?

    Thanks!

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Slow store - sometimes(!)

    is there a place I can turn that ON for now?
    admin > config > logging > display parse times
    Now at 8pm I can change pages in the store real fast, like 2-3 seconds.
    I have a store with 100,000 items and page parse time are sub-second for most all pages

    Shoppers are not patient about this and will go elsewhere
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Jun 2004
    Posts
    113
    Plugin Contributions
    0

    Default Re: Slow store - sometimes(!)

    Thanks! At the moment I'm seeing <1 sec parse time most of the time, <2 all the time. I'll see what it does tomorrow afternoon.

  4. #4
    Join Date
    Jan 2008
    Posts
    19
    Plugin Contributions
    0

    Default Re: Slow store - sometimes(!)

    Are you on a zen certified host? I was on a non-certified host and had the same issues as you are having. I moved my site to a zen certified host, subsecond pages are the norm, customers are happy! It could well be your ISP.
    justteachit

  5. #5
    Join Date
    Jun 2004
    Posts
    113
    Plugin Contributions
    0

    Default Re: Slow store - sometimes(!)

    Oh, ok, it's doing it again already (now 8:50pm):

    Parse Time: 25.991 - Number of Queries: 78 - Query Time: 25.200709677689

    Does this mean the SQL back-end took 25.200 seconds and the other .791 seconds was PHP interpretation?

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

    Default Re: Slow store - sometimes(!)

    Quote Originally Posted by Brian1234 View Post
    Parse Time: 25.991 - Number of Queries: 78 - Query Time: 25.200709677689

    Does this mean the SQL back-end took 25.200 seconds ...?
    That is correct.
    .

    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.

 

 

Similar Threads

  1. Sometimes very slow pageload (long query times)
    By Doomm in forum General Questions
    Replies: 8
    Last Post: 13 Apr 2011, 06:30 PM
  2. my website is getting very slow and sometimes not even load
    By wastaboo in forum General Questions
    Replies: 0
    Last Post: 3 Apr 2009, 01:41 AM
  3. Slow site with errors that occur sometimes
    By chalfontgifts in forum General Questions
    Replies: 1
    Last Post: 5 Oct 2008, 09:38 AM
  4. Store & Admin REALLY slow... sometimes stalls :(
    By Ledg in forum General Questions
    Replies: 3
    Last Post: 31 Aug 2007, 05:01 PM
  5. Help with (sometimes) slow site
    By lnbjohnson in forum General Questions
    Replies: 1
    Last Post: 2 May 2007, 05:17 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