WordPress.org

Ready to get started?Download WordPress

Forums

DB Cache Reloaded Fix
DB Cache Reloaded Fix (23 posts)

  1. baga
    Member
    Posted 3 years ago #

    I've just installed this plugin to speed up my site and I noticed that the number of queries are reduced but it takes longer time, for example on my home page:

    without the plugin: <!-- 494 queries. 2,699 seconds. -->

    with the plugin: <!-- 211 queries. 3,951 seconds. -->

    What does it exactly mean?

    http://wordpress.org/extend/plugins/db-cache-reloaded-fix/

  2. Ivan Kristianto
    Member
    Plugin Author

    Posted 3 years ago #

    try the default comment, it will look like this:

    <!-- Generated in 1.415 seconds. Made 21 queries to database and 71 cached queries. Memory used - 31.68MB -->

    it means i have about 92 queries made for my home page. But only 21 are made through the database, the other 71 queries are cached. cache time is 1.415 seconds and memory used for caching is 31.68MB.

    that's what it means.

    Thanks

    Ivan Kristianto

  3. baga
    Member
    Posted 3 years ago #

    Thanks for your answer Ivan.
    I just did not understand if the page loads faster or slower with your plugin: there are less queries but it takes more seconds, that's why I'm confused....

  4. finid
    Member
    Posted 3 years ago #

    I just enabled this plugin on http://linuxbsdos.com, and the site feels faster already. Even the admin end. The old cache plugin was terrible, even on the admin side.

    Thank you.

  5. baga
    Member
    Posted 3 years ago #

    I'm still confused on queries vs seconds....

  6. Ivan Kristianto
    Member
    Plugin Author

    Posted 3 years ago #

    @baga, can you try this:
    1. clear cache, and post the db cache stats here.
    2. try refresh the page 1-2 times and post the stats again here.
    I want to compare the results.

    Thanks

    Ivan
    http://wordpress.org/extend/plugins/db-cache-reloaded-fix/

  7. baga
    Member
    Posted 3 years ago #

    Hello Ivan, sorry for my late reply. I did some testing, so:

    plugin not active: <!--
    2.779 seconds
    732 queries
    28.767 MB Memory Used
    -->

    plugin active: <!-- Generated in 2.939 seconds. Made 337 queries to database and 395 cached queries. Memory used - 28.99MB -->

    Cannot tell if the page loads faster with or without using the plugin.
    Thanks for your help,
    Baga

  8. Ivan Kristianto
    Member
    Plugin Author

    Posted 3 years ago #

    Hi Baga,
    i wonder why there are many queries to your database.
    I feel that you should uninstall some plugins and show less posts per page.
    DB cache reloaded fix won't cache post and post meta.
    If you show a lot of posts i think you should lower it.

    Thanks

    Ivan

  9. baga
    Member
    Posted 3 years ago #

    Ivan thanks for your quick reply!
    I tried another test on a simpler page (less queries in it) and that's the results:

    plugin not active:
    <!--
    1.345 seconds
    229 queries
    30.488 MB Memory Used
    -->

    plugin active:
    <!-- Generated in 1.360 seconds. Made 61 queries to database and 168 cached queries. Memory used - 30.85MB -->

    The differences don't look so relevant.

  10. Ivan Kristianto
    Member
    Plugin Author

    Posted 3 years ago #

    I'm developing db cache reloaded fix to add Zend cache for optimum compatibility and faster performance. Stay tune!

    Regards

    Ivan

  11. baga
    Member
    Posted 3 years ago #

    Thanks Ivan!

  12. chrisparksaz
    Member
    Posted 3 years ago #

    Excellent application. I love DB Cache Reloaded Fix I just enabled it on my site -- and all of my clients' sites as well. When combined with HyperCache, you get a really powerful combination of technology. Must have! Thank YOU.

  13. legend717
    Member
    Posted 3 years ago #

    Plugin shit!

    plugin not active: 0.7 sec
    plugin active: 1.03 sec

    Where is the speed? lol.

  14. microonline
    Member
    Posted 2 years ago #

    Hello, I have a problem my blog had the older version of "DB Cache Reloaded" Wrapper mode enabled, switch to a few days ago "DB Cache Fix Reloaded" activate it without the wrapper as being the new version, but it shows error 500 to enter the WP administrative panel, after many attempts finally enters but it appears the plugin disabled. That it could be? Sorry for the English only speak Spanish and use a translator

  15. Ivan Kristianto
    Member
    Plugin Author

    Posted 2 years ago #

    @legend717: it depends on how big your database is and how fast your mysql server. when it comes to high traffic and large database, i'm sure this plugin will boost the performance.

    @microonline: do you have any other db cache plugin installed? such as W3 Total cache?

  16. Daedalon
    Member
    Posted 2 years ago #

    The only real way to test is to have the site respond to at least hundreds of page requests in a short period. There are services and scripts for that but I don't have one handy for you now, sorry. Posting just a single result with and a single one without the caching can be very misleading.

    Back in 2010 was a comprehensive WP cache comparison (Google cache) was done with 1,000 requests at 10 concurrent and the summary said "Overall the best out of the box cache plugin configuration in my opinion is: Hyper Cache + DB Cache Reloaded".

    Without caching the server was able to answer to 13.96 requests per second while spending 716.580 ms per request (mean average). With DB Cache Reloaded the numbers were 15.04 per second and 665.09 ms per request; 8 % faster.

    The old numbers might or might not apply, but they are in line with my gut feeling based on a small sample: DBCRF has a slight positive effect on WP speed. The best part is that it can be used with Hyper Cache (Extended) to benefit from both.

  17. x5150
    Member
    Posted 2 years ago #

    I don't see the number of queries going down with the plugin. Also, I don't see a configure settings option for the "Fix" plugin only activate/deactivate.
    How do I make the plugin work for my page?

    I'm using wp 3.2.1 and 2.2.4 reloaded fix plugin.

    <!-- Cached by DB Cache Reloaded Fix -->
    </body>
    <!-- 40 queries. 4.994 seconds. -->
    <!-- Cached by DB Cache Reloaded Fix -->
    </body>
    <!-- 40 queries. 5.087 seconds. -->
  18. Daedalon
    Member
    Posted 2 years ago #

    You have the plugin active but the caching isn't doing anything if that's all that is written in the end of your blog's HTML. Maybe it's a plugin conflict. You should see something like

    <!-- Generated in 0.267 seconds. Made 41 queries to database and 19 cached queries. Memory used - 27.2MB -->

    above the line

    <!-- Cached by DB Cache Reloaded Fix -->.

    Since you have another plugin telling you the queries after the </body> tag, the possibility of plugin conflict came to mind. Without more information it's hard to guess, but the plugin documentation may be helpful to you. Also these fixes to your DBCRF may help you locate the problem.

  19. x5150
    Member
    Posted 2 years ago #

    The queries line is from adding to my footer,

    <!-- <?php echo get_num_queries(); ?> queries. <?php timer_stop(1); ?> seconds. -->

    The other plugins I have activated are wp eMember and "Post Types Order". Other than that I have a custom theme that's it.

    So I tried the fixes, manually creating

    I got it working by creating an empty /wp-content/db-config.ini, copying /wp-content/plugins/db-cache-reloaded-fix/db.php to /wp-content/db.php and chmodding both to 777 (755 didn't work on my host).

    and then creating the "cache" directory under

    wp-content/plugins/db-cache-reloaded-fix/cache

    Now the page reports less queries but the page load time reported in firebug is the same or higher.

    <!-- Cached by DB Cache Reloaded Fix -->
    </body>
    <!-- 33 queries. 5.122 seconds. -->

    Still no other output,

    <!-- Generated in 0.267 seconds. Made 41 queries to database and 19 cached queries. Memory used - 27.2MB -->

    How do I get that working, or is the plugin working already? I can see files created under

    wp-content/plugins/db-cache-reloaded-fix/cache

  20. Daedalon
    Member
    Posted 2 years ago #

    Glad that my fixes helped you. It indeed sounds like the DBCRF plugin is working, but making its output different from normal. The amount of queries is normally should be before, not after </body> and it mentions separately the amount of queries and cached queries.

    The simplest explanation to the content of the message would be the plugin settings, where you can specify the message. This however doesn't explain why it's after </body>.

    The first thing I'd try is checking that your custom theme isn't the cause. See the documentation for wp_footer() and if it doesn't help, simply try if using another theme solves the problem. The next step I'd try is turning off the two other plugins one by one and seeing does that solve the problem. If it does, please add that plugin's tag to this conversation from the right side of your message that started the thread.

  21. x5150
    Member
    Posted 2 years ago #

    I moved the queries output one line up to just before the </body> tag so my footer.php code looks like,

    }
    });
    });
    </script>
    <?php } ?>
    
    <!-- <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> -->
    <?php wp_footer(); ?>
    <!-- <?php echo get_num_queries(); ?> queries. <?php timer_stop(1); ?> seconds. -->
    </body>
    </html>

    Still getting the same output though. I also tried using the

    set DBCR_DEBUG to true in db-cache-reloaded.php

    and

    DBCR_SAVEQUERIES in wp-config.php file

    but not getting any extra debug code in view source.

    Unfortunately this is a live membership site so I can't turn off eMember or my theme. I'd really like to know how to get a detail report of the queries though.

  22. x5150
    Member
    Posted 2 years ago #

    Ok, I just saw a message on the "Dashboard" that my DBCR plugin was not enabled. It took me to a page to activate and now I get the query output.

    Where's the settings menu for the plugin under "Plugins" menu? This is all I have,

    DB Cache Reloaded Fix
    Deactivate | Edit
    The fastest cache engine for WordPress, that produces cache of database queries with easy configuration. (Disable and enable caching after update). Now compatible with WordPress 3.1.

    Version 2.2.4 | By Ivan Kristianto | Visit plugin site

    There should be a "Settings" link here that goes to

    ../wp-admin/options-general.php?page=db-cache-reloaded-fix/db-cache-reloaded.php

    Here's some query output, the page load is still slow, probably slower with the plugin activated.

    DBCRF
    
    1st
     <!-- Generated in 5.167 seconds. Made 36 queries to database and 4 cached queries. Memory used - 14.34MB -->
    <!-- Cached by DB Cache Reloaded Fix -->
    
    2nd
                  <!-- Generated in 4.743 seconds. Made 17 queries to database and 23 cached queries. Memory used - 14.34MB -->
    <!-- Cached by DB Cache Reloaded Fix -->
    
    3rd
                 <!-- Generated in 4.917 seconds. Made 17 queries to database and 23 cached queries. Memory used - 14.34MB -->
    <!-- Cached by DB Cache Reloaded Fix -->
    
    4th
    div>
    </div>               <!-- Generated in 5.455 seconds. Made 17 queries to database and 23 cached queries. Memory used - 14.34MB -->
    <!-- Cached by DB Cache Reloaded Fix -->
  23. Daedalon
    Member
    Posted 2 years ago #

    The settings for this and most other plugins can be found under Settings instead of under Plugins menu on the left side of the admin pages.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic