Page 1 of 14 12311 ... LastLast
Results 1 to 10 of 136
  1. #1

    Default Query Cache v1.0

    Hello,

    This is my first official contribution.

    I've created Query Cache contribution that might help improve performance of Zen Cart. It prevents Zen Cart from executing the same queries many times, which can speed up Your store. I tested it on few stores and it usually reduces number of queries from 30% to 60%. Installation instructions and contribution can be found here:
    http://www.data-diggers.com/query-cache
    There's also screencast showing how to install this module. Please let me know what You think about it. In case of any issues please contact me via pm or via email ([email protected])

    Note: there will be new version of this module, which will further reduce number of queries sent to MySQL.

  2. #2
    Join Date
    Mar 2004
    Posts
    688
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    Thank You!
    Amazing results! From 1060 down to 472 on one of my sites...

  3. #3

    Default Re: Query Cache v1.0

    Happy to hear that:)
    If You've found any bugs or have any suggestions please write and I'll try to fix bugs/implement new features.

  4. #4
    Join Date
    May 2007
    Location
    Montebello, CA
    Posts
    40
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    Thank you i got a 60% nice job
    https://www.tni-wireless.com

    Zen Cart V1.5.4 with Tableau Responsive Theme.

  5. #5

    Default Re: Query Cache v1.0

    New version of Query Cache is available. In nutshell, it reduces query count by 80% ( v1.0 reduces query count by about 50%, so it's huge improvement). Results on Zen Cart Demo Store:
    • without Query Cache: 950+ queries
    • with Query Cache v1.5: about 200 queries

    Download updated version here. Read my updated blog to find out more.

  6. #6
    Join Date
    Aug 2008
    Posts
    13
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    nice JOB work great at test site http://shop.kafeshop.cz ThnkZ

  7. #7
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Query Cache v1.0

    I wonder if this is the best approach to caching it. Why not editing the db class only, and then use the whole query string, md5 it to get a (fairly)u?
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  8. #8

    Default Re: Query Cache v1.0

    Quote Originally Posted by yellow1912 View Post
    I wonder if this is the best approach to caching it. Why not editing the db class only, and then use the whole query string, md5 it to get a (fairly)u?
    I assume You're referring to changes in functions_categories.php?
    Sure, it would be much more elegant way of doing this, but unfortunately (I tested it), it would be slow(parsing queries and argument extraction takes more time then executing it). In fact, I wanted to do it in similar way You wrote, but in performance contribution performance is more important then beautiful code.

  9. #9
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Query Cache v1.0

    I dont know why my comment got cut half way, anyhow what I meant is: if we treat each query string as an identifier (and by md5 the query content we would have a rather unique identifier for each query), then we can store each query result in a unique file?
    I think the most time consuming would serialization and un-serialization of the object returned by the query (to save/restore the result), Maybe we can use some easier method to store it?
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  10. #10

    Default Re: Query Cache v1.0

    Quote Originally Posted by yellow1912 View Post
    I dont know why my comment got cut half way, anyhow what I meant is: if we treat each query string as an identifier (and by md5 the query content we would have a rather unique identifier for each query), then we can store each query result in a unique file?
    Why would You like to treat query string with md5? I use whole query string as identifier (in array) in my class and it's quite fast.

    Storing results in files is not a good idea imho. You never know if cached results are consistent with database. Also, 99% of queries execute in 0.01 sec or so (per query). Storing / restoring results of such queries would take much more time then executing it.
    Besides, MySQL has it's own query cache (unfortunately hosting companies sometimes turn it off or forgot to turn it on) that does the same thing, only better, because results from cache are always consistent with database.

 

 
Page 1 of 14 12311 ... 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