WordPress.org

Ready to get started?Download WordPress

Forums

DB Cache Reloaded Fix
DB Cache Reloaded Fix for Multisite (13 posts)

  1. RonStrilaeff
    Member
    Posted 2 years ago #

    Ivan,

    What are the possible bad consequences of enabling your cache plugin on several sub-sites under a multisite WP installation? Would it totally break?

    The technique of DB caching seems superior to page caching but W3 Total Cache (which has that) is just WAY too complicated and some of my pages would not refresh at all, even with ctrl-F5. So I'm wanting yours to work since Caching is one of those system utilities that should just work quietly in the background so we humans can get on with OUR work and not babysit it.

    Good luck,
    Ron

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

  2. Gauhar Kachchhi
    Member
    Posted 2 years ago #

    I have enabled it on my Multisite http://articles.architectjaved.com and there have been no problems with it...

  3. Daedalon
    Member
    Posted 2 years ago #

    Ron, if you feel that W3 Total Cache is too complicated, you may want to try Hyper Cache which requires minimal setup. This plugin was the fastest among W3 Total Cache in a 2009 comparison.

    Another reportedly easy option is WP Super Cache, which is one of the featured plugins on the plugins front page.

    The speedup from DB Cache Reloaded (Fix) is likely small but worth a try after Ivan has time to incorporate the fixes that make the installation and activation easier.

  4. Frederick Townes
    Member
    Posted 2 years ago #

    @RonStrilaeff, any other questions?

  5. RonStrilaeff
    Member
    Posted 2 years ago #

    Thanks for replying Fredrick. I abandoned DB-Cache-Reloaded, not sure why now.

    My two main production sites chowstalker.com and dessertstalker.com are using QuickCache which seems to have helped with the "First Byte Time", but webpagetest.org still gives me an "F" for "Cache Static Content" (which I thought was the main purpose of a caching plugin). But they are chugging along fine with no one complaining of downtime or slowness. They have issues with an inefficient, db-heavy plugin so will eventually be replaced with a new design to take advantage of the built in features of WP3.x, so I'm not worried about them until something breaks.

    For future projects I'd like to use something more robust (like W3 Total Cache or WP Super Cache), but I'm afraid I will need a university course to figure out how to make them work. Does W3TC work with out-of-the-box, default settings so I can just activate it and let it work in safe (but probably not optimal) mode?

  6. Frederick Townes
    Member
    Posted 2 years ago #

    It should work out of the box and if it doesn't I would like to work with you to learn why, so please submit a bug submission form when you try it again if you have issue working through the installation instructions.

  7. RonStrilaeff
    Member
    Posted 2 years ago #

    Hi,

    I will install W3TC on a test site soon and let you know how it works out of the box. I probably just didn't think it through back then since I was sort of in panic mode when my site was "down". But I know more of the terminology now and it should make more sense.

    In case I need it, are you referring to the bug submission form here: http://wordpress.org/tags/w3-total-cache ?

    Thanks for your support!

    Ron

  8. Frederick Townes
    Member
    Posted 2 years ago #

    No, the plugin itself has a support tab.

  9. Paul Phillips
    Member
    Posted 2 years ago #

    > Ron Strilaef

    "Cache Static Content" means images, javascript and css files. It's most likely a problem in your .htaccess file.

    Adding something like the following will enable browser side caching of static content

    <IfModule mod_mime.c>
        AddType text/css .css
        AddType application/x-javascript .js
        AddType text/x-component .htc
        AddType text/html .html .htm
        AddType text/richtext .rtf .rtx
        AddType image/svg+xml .svg .svgz
        AddType text/plain .txt
        AddType text/xsd .xsd
        AddType text/xsl .xsl
        AddType text/xml .xml
        AddType video/asf .asf .asx .wax .wmv .wmx
        AddType video/avi .avi
        AddType image/bmp .bmp
        AddType application/java .class
        AddType video/divx .divx
        AddType application/msword .doc .docx
        AddType application/vnd.ms-fontobject .eot
        AddType application/x-msdownload .exe
        AddType image/gif .gif
        AddType application/x-gzip .gz .gzip
        AddType image/x-icon .ico
        AddType image/jpeg .jpg .jpeg .jpe
        AddType application/vnd.ms-access .mdb
        AddType audio/midi .mid .midi
        AddType video/quicktime .mov .qt
        AddType audio/mpeg .mp3 .m4a
        AddType video/mp4 .mp4 .m4v
        AddType video/mpeg .mpeg .mpg .mpe
        AddType application/vnd.ms-project .mpp
        AddType application/x-font-otf .otf
        AddType application/vnd.oasis.opendocument.database .odb
        AddType application/vnd.oasis.opendocument.chart .odc
        AddType application/vnd.oasis.opendocument.formula .odf
        AddType application/vnd.oasis.opendocument.graphics .odg
        AddType application/vnd.oasis.opendocument.presentation .odp
        AddType application/vnd.oasis.opendocument.spreadsheet .ods
        AddType application/vnd.oasis.opendocument.text .odt
        AddType audio/ogg .ogg
        AddType application/pdf .pdf
        AddType image/png .png
        AddType application/vnd.ms-powerpoint .pot .pps .ppt .pptx
        AddType audio/x-realaudio .ra .ram
        AddType application/x-shockwave-flash .swf
        AddType application/x-tar .tar
        AddType image/tiff .tif .tiff
        AddType application/x-font-ttf .ttf .ttc
        AddType audio/wav .wav
        AddType audio/wma .wma
        AddType application/vnd.ms-write .wri
        AddType application/vnd.ms-excel .xla .xls .xlsx .xlt .xlw
        AddType application/zip .zip
    </IfModule>
    <IfModule mod_expires.c>
        ExpiresActive On
        ExpiresByType text/css A31536000
        ExpiresByType application/x-javascript A31536000
        ExpiresByType text/x-component A31536000
        ExpiresByType text/html A3600
        ExpiresByType text/richtext A3600
        ExpiresByType image/svg+xml A3600
        ExpiresByType text/plain A3600
        ExpiresByType text/xsd A3600
        ExpiresByType text/xsl A3600
        ExpiresByType text/xml A3600
        ExpiresByType video/asf A31536000
        ExpiresByType video/avi A31536000
        ExpiresByType image/bmp A31536000
        ExpiresByType application/java A31536000
        ExpiresByType video/divx A31536000
        ExpiresByType application/msword A31536000
        ExpiresByType application/vnd.ms-fontobject A31536000
        ExpiresByType application/x-msdownload A31536000
        ExpiresByType image/gif A31536000
        ExpiresByType application/x-gzip A31536000
        ExpiresByType image/x-icon A31536000
        ExpiresByType image/jpeg A31536000
        ExpiresByType application/vnd.ms-access A31536000
        ExpiresByType audio/midi A31536000
        ExpiresByType video/quicktime A31536000
        ExpiresByType audio/mpeg A31536000
        ExpiresByType video/mp4 A31536000
        ExpiresByType video/mpeg A31536000
        ExpiresByType application/vnd.ms-project A31536000
        ExpiresByType application/x-font-otf A31536000
        ExpiresByType application/vnd.oasis.opendocument.database A31536000
        ExpiresByType application/vnd.oasis.opendocument.chart A31536000
        ExpiresByType application/vnd.oasis.opendocument.formula A31536000
        ExpiresByType application/vnd.oasis.opendocument.graphics A31536000
        ExpiresByType application/vnd.oasis.opendocument.presentation A31536000
        ExpiresByType application/vnd.oasis.opendocument.spreadsheet A31536000
        ExpiresByType application/vnd.oasis.opendocument.text A31536000
        ExpiresByType audio/ogg A31536000
        ExpiresByType application/pdf A31536000
        ExpiresByType image/png A31536000
        ExpiresByType application/vnd.ms-powerpoint A31536000
        ExpiresByType audio/x-realaudio A31536000
        ExpiresByType image/svg+xml A31536000
        ExpiresByType application/x-shockwave-flash A31536000
        ExpiresByType application/x-tar A31536000
        ExpiresByType image/tiff A31536000
        ExpiresByType application/x-font-ttf A31536000
        ExpiresByType audio/wav A31536000
        ExpiresByType audio/wma A31536000
        ExpiresByType application/vnd.ms-write A31536000
        ExpiresByType application/vnd.ms-excel A31536000
        ExpiresByType application/zip A31536000
    </IfModule>
  10. Frederick Townes
    Member
    Posted 1 year ago #

    Anyone having any related issues here?

  11. Daedalon
    Member
    Posted 1 year ago #

    Frederick: I wanted to ask someone about Minify, and you'll surely know. The question is, whether it either forces or allows for combining the .js and/or .css files so they're all transmitted at once? I know the main function of Minify sometimes causes problems, but this shouldn't, while it would still provide a speed benefit as there'd be ideally only one JS and one CSS request.

    Ron and Paul:

    I'm currently using WP Super Cache on our newest site and Hyper Cache (not extended) on the older ones. WPSC has three caching modes, two of which require no more setup than just saving the option. The third one required copy-pasting a bit of .htaccess code, which I did to BulletProof Security's custom code section, but that was all. The site is now lightning fast, but might still benefit from Paul's .htaccess addition that makes the JavaScript, CSS and image files stay in browser's cache.

    Paul's .htaccess tells the browser to cache the files for 365 days (31 536 000 seconds). I wouldn't personally consider anything longer than a month (2 592 000 seconds) and would most likely choose either 1 or 2 weeks (604 800 or 1 209 600 seconds). That should provide a speed benefit while also making sure there'll be no rare conditions where someone keeps seeing older versions of updated content for ages. I think Google serves the forever-unchanging jQuery files they host with a 2 week expiration date.

  12. Frederick Townes
    Member
    Posted 1 year ago #

    In auto mode, W3TC will try to make a single file. In manual mode the same is true however manual mode is the only way to exclude files or add 3rd party files. Minify is one of the best performance wins for the client-side of things.

    Browser cache is another huge performance win and W3TC can manage the policies for your entire site and allow you to remove any existing rules (policies).

  13. Daedalon
    Member
    Posted 1 year ago #

    Thanks for the answer Frederick, that sounds good. I might give W3TC another go if increasing user amounts on our site prompt us to look for speed optimization. While using W3TC some two years ago I ran into a sitewide white screen of death that required FTP removal of the plugin to resolve. Hopefully during these two years the plugin has learned to avoid or gracefully overcome more of these situations.

    Right now I'm pretty happy with WPSC. The only issues so far are the admin bar's Delete Cache button that sometimes shows and sometimes doesn't, possibly due to a plugin conflict, and the fact that garbage collection stopped completely when set to run first at 00:00 and then hourly. It runs like a clock now when it's set to run at a specified interval (300 seconds). Site is fast and the plugin causes no extra maintenance besides having to keep a browser tab open displaying the plugin's clear cache option while developing. Minifying and combining the .js and .css files could make things faster especially for mobile connections, but as setting that up takes time and can lead to unexpected problems, it's not yet among the immediate priorities.

    Ideally I'd just add a Minify solution to my current setup and manually choose for it to combine the files that are not under development. However, WP Minify has several unsolved critical issues raised during the last month and the other plugin I know of, Minify, is so new that it has only one rating and an unsolved critical issue. W3TC is tried and tested, but is quite a mammoth to install just for the Minify.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic