Page 10 of 14 FirstFirst ... 89101112 ... LastLast
Results 91 to 100 of 136
  1. #91
    Join Date
    Apr 2008
    Posts
    82
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    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!!!!!

  2. #92
    Join Date
    Sep 2008
    Location
    DownUnder, overlooking South Pole.
    Posts
    976
    Plugin Contributions
    6

    Default Re: Query Cache v1.0

    Quote Originally Posted by lat9 View Post
    You're right ... there were changes to both query_factory.php and functions_categories between zc1.3.8a and 1.3.9c. The attached zip-file has the merged version that combines Query Cache v1.6 and the respective files from ZC 1.3.9c; there is no directory structure in the zip-file, so you need to copy the files to:

    /includes/classes/db/mysql/query_factory.php
    /includes/functions/functions_categories.php
    Hi all

    I am getting bucket loads (around one per query) of the following error messages with the above updates.

    [07-Jul-2010 08:36:33] PHP Warning: mysql_data_seek() [<a href='function.mysql-data-seek'>function.mysql-data-seek</a>]: Offset 0 is invalid for MySQL result index 395 (or the query data is unbuffered) in ...\includes\classes\query_cache.php on line 38
    After having tried so many combinations of the switches, I have run out of ideas how to fix.

  3. #93
    Join Date
    Dec 2009
    Posts
    5
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    I really appreciate your good work on QueryCache, I have read your code and want to apply in my website, but there is one thing I need to know before:
    In your code,you check the existing of Cache objects, if exists, return directly, if not exists, query from database and then return. but when cache create and things changed, how can I init all the things so that it can read all the things from database again? just like SEO cache.

  4. #94
    Join Date
    Jul 2007
    Location
    Roseville, Michigan
    Posts
    188
    Plugin Contributions
    0

    Default Query Cache v1.6 and SQL_CACHE_METHOD

    Zencart 1.3.9f

    If I install this unto my site, does it matter what the setting is for the SQL_CACHE_METHOD? (none, file, or db)

  5. #95
    Join Date
    Apr 2008
    Location
    Flint, Michigan
    Posts
    687
    Plugin Contributions
    0

    Default Re: Query Cache v1.6

    The download file does not include Zen-cart version 1.3.9. Has anyone has success with following 1.3.8 instead?

    Thanks, Kim

  6. #96
    Join Date
    Sep 2010
    Posts
    1
    Plugin Contributions
    0

    Default Re: Query Cache v1.0

    Quote Originally Posted by dw08gm View Post
    Hi all

    I am getting bucket loads (around one per query) of the following error messages with the above updates.



    After having tried so many combinations of the switches, I have run out of ideas how to fix.
    I'm seeing the same thing on my site. Did anyone ever solve this problem? I'm running 1.3.9f.

  7. #97
    Join Date
    Sep 2008
    Location
    DownUnder, overlooking South Pole.
    Posts
    976
    Plugin Contributions
    6

    Default Re: Query Cache v1.0

    I got no replies so I decided to abandon the mod under 139.

    Under 138, I had found only a modest improvement in performance, so abandoning the mod in 139 was no real loss as far as my site is concerned.

    Since abandoning, I have found other ways to improve performance, although I have only a vague memory of what was done.

    Cheers

  8. #98

    Default Re: Query Cache v1.0

    QueryCache v1.7 for Zn Cart 1.3.9h has been released. Currently the mod is in 'beta' stage, but it should be stable.
    Download QueryCache v1.7-beta-zc-1.3.9h
    Please report any bugs here or on www.data-diggers.com

  9. #99

    Default Re: Query Cache v1.0

    Quote Originally Posted by imustbeme View Post
    I'm seeing the same thing on my site. Did anyone ever solve this problem? I'm running 1.3.9f.
    Install the version for 1.3.9h

  10. #100

    Default Re: Query Cache v1.6 and SQL_CACHE_METHOD

    Quote Originally Posted by smoke133 View Post
    Zencart 1.3.9f

    If I install this unto my site, does it matter what the setting is for the SQL_CACHE_METHOD? (none, file, or db)
    It doesn't matter.

 

 
Page 10 of 14 FirstFirst ... 89101112 ... 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