Page 11 of 14 FirstFirst ... 910111213 ... LastLast
Results 101 to 110 of 136
  1. #101

    Default Re: Query Cache v1.0

    Quote Originally Posted by Dan123 View Post
    Hi all, first of all thanks for this great module!!!
    I have a question, I found that I have 2 queries that are pretty slow. the first one is caused by my SSU module, when I checked ssu_cache table, it has more than 100,000 rows. And the second one is whoisonline. Did anybody else have this issue and knows how to fix it????
    Thank you!!!!!
    I highly recommend changing storage engine of whos_online table to InnoDB. You'll avoid locking issues with this table (it's updated on EVERY request).

  2. #102
    Join Date
    Apr 2010
    Posts
    100
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    I tried that, it reduced the number of queries, but looks like the parse time is still high, especiall on the first hit (where there is no hit to my site in the previous 15 mins or so), it can be as high as 10+ seconds:

    http://www.kingoflaptops.com/

    :-(

  3. #103

    Default Re: Query Cache v1.0

    Quote Originally Posted by Cindy2010 View Post
    I tried that, it reduced the number of queries, but looks like the parse time is still high, especiall on the first hit (where there is no hit to my site in the previous 15 mins or so), it can be as high as 10+ seconds:

    http://www.kingoflaptops.com/

    :-(
    Can You check if query time is also high? What times do You get? PM me as it's most probably not related to QueryCache and We shouldn't continue the discussion here.

  4. #104
    Join Date
    Jan 2011
    Posts
    65
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    OMG Thank you for this!!!

    I was getting hit with fastcgi timeouts during the checkout process because my sql queries were taking too long when customers had a lot of items in the cart, and sure enough when I turned on page parse time logging, I was showing in excess of 30,000 queries during checkout.

    I was struggling with a solution and almost had to consider a vps to possibly help with the parse times.

    Your addon reduced it to less than 3,000!!! It performs even better than your claim of 80% reduction! Now I don't even need to consider moving servers. I can't thank you enough for this addon!

    Oh and btw I'm using your beta version, and I'm on zencart v1.3.9h
    Last edited by RoboPhung; 14 Apr 2011 at 09:56 AM. Reason: Adding additional information

  5. #105
    Join Date
    May 2010
    Location
    Cyberspace
    Posts
    376
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    When I install this add-on it duplicates my document categories in ZC: s regular categories, is there a work around?

  6. #106

    Default Re: Query Cache v1.0

    Quote Originally Posted by Soniccc View Post
    When I install this add-on it duplicates my document categories in ZC: s regular categories, is there a work around?
    I can’t reproduce that behavior on clean Zen-Cart v1.3.9h. Which version of ZC do You have? Have You installed and other addons?
    You can view QC1.7 beta on zc 1.3.9h here:
    Zen Cart v1.3.9h with Query Cache
    it doesn’t duplicate Documents category.

    Can You share a link to the store on which it occurs?

  7. #107
    Join Date
    Oct 2009
    Posts
    93
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    Nice add on but I have one issue with this cache query.

    After installing cache query and removing cache from my mozilla firefox i found the time for home page:

    Parse Time: 8.161 - Number of Queries: 485 - Query Time: 1.05650873018

    This is really high parse time.

    Without Cache query I get:

    Parse Time: 1.161 - Number of Queries: 587 - Query Time: 1.05650873018

    Now with cache query if i open next page I get almost half number of queries which is a best job done by Cache query.

    I'm little confuse about why does the time increases to very high if i remove all caches from mozilla firefox and then open any page but subsequent page opens at very low parse time.

    What should I do in that case?

  8. #108
    Join Date
    Jul 2011
    Posts
    7
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    Where does QueryCache store its cache ? In a file ?

    For how long is the result of a select query cached ?




    Can this be made to work with something like APC or memcache?

  9. #109
    Join Date
    May 2007
    Posts
    37
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    Update for Zencart 1.5 please ????

  10. #110
    Join Date
    Dec 2011
    Posts
    1
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    Contemplating the 1.39 -> 1.5 upgrade, but am not clear if QueryCache works fully, or partly, or not at all with ZC v1.5. The lack of chatter on this, given the large number of users of the mod, suggests it works at least in part. Can anyone confirm?

    Regards

 

 
Page 11 of 14 FirstFirst ... 910111213 ... LastLast

Similar Threads

  1. v139e Query cache AND Image cache
    By ttfan in forum General Questions
    Replies: 0
    Last Post: 3 Aug 2012, 12:18 PM
  2. Query Cache Info?
    By Miff in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 13 Dec 2011, 02:07 PM
  3. Which Query Cache for version 1.3.9d
    By alx-tc in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 28 Oct 2011, 01:34 PM
  4. Re: Simple Cache vs. Query Cache
    By matteoraggi in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 12 May 2011, 11:09 AM
  5. Simple Cache vs. Query Cache vs. Magneticone Performance Mod?
    By NBordeau in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 24 May 2010, 03:55 PM

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