infinix x yugatech

WP DB Cache vs. WP SuperCache

Listen to article

Most bloggers are familiar with WP SuperCache, a WordPress plugin that dynamically caches WP by converting them into static pages, thereby avoiding repeated database queries. While it’s very effective, this approach though has had several drawbacks. Then, there’s the newer one called WP DB Cache.

Let me break down some of the advantages and dis-advantages of WP-SuperCache and DB-Cache so you can see which of the two plugins is better for your blog.

WP SuperCache

  • Creates static version of each cached pages so it can easily eat up a lot of web space though that will depend how many pages your blog has (remember that tags, archives, and paged comments are also separate pages). I’ve seen WP-SuperCache easily eat up 300+MB of webspace for larger blogs.
  • Very effective for blogs that experience high surge in traffic for a single page (like being Dugg, SlashDot or Stumbled Upon) as the target page is automatically cached for a given period of time. That page basically serves static HTML sparing all database queries (unless of course visitors on that page comment a lot).
  • Additional features like Lock Down adds a layer of protection for high-trafficked pages that keeps on getting updated by visitor comments. This feature delays the display of new comments so it can just serve a single static page for that period.
  • Has some page delivery problems when enabled with WP-Mobile. The mobile version of the blog homepage is sometimes cached and served as the static page.
  • Leaves some stale pages. The cache does not refresh unless content on a page is edited. That leaves the Sidebar stale when new contents are added to it.

WP DB Cache

  • Caches DB queries instead of entirely making the page static. Reduces the number of DB queries on all pages but not all.
  • Does not save individual pages as static files so it doesn’t use a lot of web space for caching.
  • Might not be able to handle a sudden surge of traffic on a single page (in case of Digg or Slashdot flood).
  • Blog elements stay fresh (sidebar, widgets, etc.)
  • Effective for blogs that have hundreds or thousands of actively viewed pages.

I think the main difference between WP SuperCache and WP DB Cache is that the latter’s caches are re-used on all pages of the blog while WP-SuperCache only serves cache on a per page basis.

Best caching benefit for WP DB Cache: 1,000 pages of a blog are visited just once but all at the same time.

Best caching benefit for WP SuperCache: 1,000 visitors view a single page of a blog all at the same time.

Depending on which of the two scenarios best fit your blog, you can choose between the two caching plugins.

Frequently Asked Questions

What is the main difference between WP SuperCache and WP DB Cache?
WP SuperCache creates static versions of cached pages, while WP DB Cache caches database queries.
What is a drawback of WP SuperCache mentioned in the article?
WP SuperCache can consume a lot of web space, up to 300+ MB for larger blogs.
What issue does WP SuperCache have with WP-Mobile?
It sometimes caches and serves the mobile version of the blog homepage as the static page.
React to this article:
Written by
Abe Olandres

Abe Olandres

Editor-in-chief

Abe is the founder and Editor-in-Chief of YugaTech with over 20 years of experience in the technology industry. He is one of the pioneers of blogging in the country and is considered by many as the Father of Tech Blogging in the Philippines.

View all posts by Abe Olandres →

22 Comments

AR
Arnulfo · 15 years ago

I experienced an increase in wordpress core files and error log files being dumped in several of my wordpress blogs since I install wp-superchache. The plug-in creates static pages of posts that it increases web space usage. Consequently, my account was suspended because of too many files in my shared hosting account, though the tech support of the hosting company adviced me to use wp-supercache to optimize performance of my blogs. I was told to delete an excess of 30,000 files to restore the service. However, I didn’t uninstall wp-supercahce yet and will be checking to confirm if it really caused the errors and also the dumping of core files.


Reply
DA
Dawnson · 16 years ago

Maybe I can use all of them.


Reply
AB
Abe Olandres Editor-in-chief · 17 years ago

@jhay, that should be the upgrade path. I have great respects with the guys at MT.


Reply
CA
calvin · 17 years ago

mukhang db cache pala yung bagay saken.


Reply
JH
jhay · 17 years ago

If all else fails, is it time to get a VPS or a dedicated server hosting?

How about Media Temple’s approach to hosting websites?


Reply
AB
Abe Olandres Editor-in-chief · 17 years ago

If that’s the case, I’d run SuperCache and set the expiration of the cache at 99999999 seconds.


Reply
SE
Selboy · 17 years ago

to make it more clearer, if your blog is visited by 1,000+ visitors viewing 1,000 pages of your blog simultaneously then you need the dbcache plugin.

However, if your 1,000+ visitors are just viewing a single page at the same time, then better get the supercache.

but what about if 1,000 visitors are visiting 1,000 pages and another 1,000 visitors are visiting only a single page but these 2,000 visitors visit the blog at the same time, what plugin should we need? Do we need to install both of them? just wondering… :-)


Reply
BR
BrianB · 17 years ago

Abe, I need a lock down too in the blog. Is it available?


Reply
AB
Abe Olandres Editor-in-chief · 17 years ago

Checked it before. WP SuperCache isn’t compatible with your hosting platform.


NA
nathan · 17 years ago

stable na po ba ang “wp db cache” plugin?


Reply
AB
Abe Olandres Editor-in-chief · 17 years ago

@nathan : So far okay naman sya.


Leave a Reply

Loading next article...