Speeding Up Wordpress - Database Cache - GoFuckYourself.com

wehateporn · 10-08-2012, 03:42 PM

I've been trying to speed up a heavy WordPress site of mine for a while now, for example I serve the static images from another server, I have a WP Cache installed etc. One thing that I had missed until now was a Database Cache, so I've just tested out the one below

DB Cache Reloaded Fix http://wordpress.org/extend/plugins/...-reloaded-fix/

and so far according to the speed test I'm using at Pingdom

http://tools.pingdom.com

it's now showing better speeds than I've ever had on the site since moving to Wordpress

It's early days, maybe it will all crash in a couple of hours, but I've heard other good reports to.

I write this thread in case this is of use to you

or in case Fris comes in to tell me I'm doing it all wrong

TheSenator · 10-08-2012, 03:46 PM

W3 Total Cache can do a lot.

I have one of the biggest adult sites using WordPress CMS.

ICQ and I can help you out.

wehateporn · 10-08-2012, 03:52 PM

Hey TheSenator,

Thanks, I've been using W3 Total Cache myself too, it does help a lot, but now that I've also added the database cache, they seem to be working very well in conjunction. I've never see my site perform so well in speed tests.

Thanks for the offer on ICQ, I don't have that installed, but any other tips are always appreciated

Quote:

Originally Posted by TheSenator

W3 Total Cache can do a lot.

I have one of the biggest adult sites using WordPress CMS.

ICQ and I can help you out.

wehateporn · 10-08-2012, 04:22 PM

I have tried other Caches before, but this one seems too good to be true, even with the "Expire a cached query after" set on just 60 minutes.

If it seems to good to be true, it probably is...I'll keep you updated

TheSenator · 10-08-2012, 04:33 PM

W3 has database caching .. r u using both at the same time?

wehateporn · 10-08-2012, 04:37 PM

Quote:

Originally Posted by TheSenator

W3 has database caching .. r u using both at the same time?

I was using Database Caching in W3, then when I installed the new plugin it automatically took over the Database Caching from W3, the rest of W3 kept running. So far running them both together seems to bring the best speeds by far

wehateporn · 10-08-2012, 04:50 PM

Quote:

Originally Posted by TheSenator

W3 has database caching .. r u using both at the same time?

Here are some pages which discuss combining different types of WordPress Cache

Should You Use DB Cache Reloaded in Addition to WP Super Cache?

http://www.ehow.com/info_12229510_sh...#ixzz28kqRC2gS

Hyper Cache + DB Cache Reloaded Fix + Wp Minify = The SuperWordPress !

http://www.bdtechie.com/hyper-cache-...uperwordpress/

Best WP Super Cache Alternative: HyperCache, DB Cache

http://geeknizer.com/best-fastest-al...#ixzz28kqb3jTD

Quote from the link above:-

"Why both still work, together.

Practically, when you run them collectively, DB Cache Reloaded takes precedence, the first time page is loaded. On subsequent page loads, it always has at least few queries cached by DB Cache Reloaded. Proof is, the cached queries increase with each time new page is reloaded. This, as a result, allows a new non-hypercached page to load quicker, since we already have few cached queries fro the new page, which is then saved into hyper cache for further visitors, Making it non-conflicting combo.

I saw the improvement in Cache Misses pages on Statistics. The missed pages were alot faster than before. (order of 4x times)

Overall, This combo has given the fastest load times ever. It enabled me achieve best of the both worlds, without comprimisng on any aspect, beyond what WP SuperCache has to offer."

OneBallJohn · 10-08-2012, 05:06 PM

I've got a pretty heavy WP install that I've recently had some cache issues with. I think I'll install these two plugin you're recommending and see if things change for the better.

Any things I should look out for when installing or configuring these two?

Thanks for the thread.

wehateporn · 10-08-2012, 05:15 PM

It's a while since I first installed W3, so I can't remember off the top of my head, there are lots of features in there that I didn't use, like CDN. It still worked well. If there's something it needs you to do it tends to explain precisely

As for the database cache, it starts with default cache expire of 5 minutes, I've moved it up to 60 minutes to see how it goes. I'm just testing though at this stage

Quote:

Originally Posted by OneBallJohn

I've got a pretty heavy WP install that I've recently had some cache issues with. I think I'll install these two plugin you're recommending and see if things change for the better.

Any things I should look out for when installing or configuring these two?

Thanks for the thread.

OneBallJohn · 10-08-2012, 06:00 PM

Sounds simple enough. Thanks again.

Quote:

Originally Posted by wehateporn

It's a while since I first installed W3, so I can't remember off the top of my head, there are lots of features in there that I didn't use, like CDN. It still worked well. If there's something it needs you to do it tends to explain precisely

As for the database cache, it starts with default cache expire of 5 minutes, I've moved it up to 60 minutes to see how it goes. I'm just testing though at this stage

TheSenator · 10-08-2012, 06:16 PM

30 days
Pageviews: 3,541,217

I have APC(Alternative PHP Cache) installed with Database and Object cache turned on.

I have the database and object cache expiring every 30 minutes.

Brujah · 10-08-2012, 06:56 PM

looks like db cache reloaded uses a flat file cache, instead of a db or memory cache?

Nasty · 10-08-2012, 08:12 PM

Quote:

Originally Posted by TheSenator

30 days
Pageviews: 3,541,217

I have APC(Alternative PHP Cache) installed with Database and Object cache turned on.

I have the database and object cache expiring every 30 minutes.

I run pretty much the same thing, seems to be the fastest combination I have found

wehateporn · 10-09-2012, 06:31 AM

Thanks for sharing that

Quote:

Originally Posted by TheSenator

30 days
Pageviews: 3,541,217

I have APC(Alternative PHP Cache) installed with Database and Object cache turned on.

I have the database and object cache expiring every 30 minutes.

TheSenator · 10-09-2012, 08:14 AM

Why do you have all your links opening up a new page?

wehateporn · 10-09-2012, 08:17 AM

Quote:

Originally Posted by TheSenator

Why do you have all your links opening up a new page?

It brings me more affiliate clicks and sales, I've tested that one on a number of occasions always with the same outcome

TheSenator · 10-09-2012, 08:24 AM

You should also use redirection/cloak links to your affiliates.

wehateporn · 10-09-2012, 08:25 AM

Quote:

Originally Posted by TheSenator

You also use redirection/cloak links to your affiliates.

Where are you seeing that? It doesn't sound like me, or are you saying I should do? I have heard reports that it increases sales

TheSenator · 10-09-2012, 08:29 AM

Quote:

Originally Posted by wehateporn

Where are you seeing that? It doesn't sound like me, or are you saying I should do? I have heard reports that it increases sales

I meant that you should use a redirection script like Pretty Links.

wehateporn · 10-09-2012, 08:30 AM

Quote:

Originally Posted by TheSenator

I meant that you should use a redirection script like Pretty Links.

I was reading this just the other day, looks like I'll need to get onto it. Thanks for the tip

Did you notice a good difference when you first started redirecting/cloaking?

TheSenator · 10-09-2012, 08:50 AM

Quote:

Originally Posted by wehateporn

I was reading this just the other day, looks like I'll need to get onto it. Thanks for the tip

Did you notice a good difference when you first started redirecting/cloaking?

I did it because I did not want to leak SEO juice.

wehateporn · 10-09-2012, 08:52 AM

Quote:

Originally Posted by TheSenator

I did it because I did not want to leak SEO juice.

Very good reason!

This is my next upgrade for sure

10-08-2012, 03:42 PM	#1
wehateporn Promoting Debate on GFY Industry Role: Join Date: Apr 2007 Posts: 27,173	Speeding Up Wordpress - Database Cache I've been trying to speed up a heavy WordPress site of mine for a while now, for example I serve the static images from another server, I have a WP Cache installed etc. One thing that I had missed until now was a Database Cache, so I've just tested out the one below DB Cache Reloaded Fix http://wordpress.org/extend/plugins/...-reloaded-fix/ and so far according to the speed test I'm using at Pingdom http://tools.pingdom.com it's now showing better speeds than I've ever had on the site since moving to Wordpress It's early days, maybe it will all crash in a couple of hours, but I've heard other good reports to. I write this thread in case this is of use to you or in case Fris comes in to tell me I'm doing it all wrong __________________ Sexy Girls Teasing

10-08-2012, 03:46 PM	#2
TheSenator Too lazy to set a custom title Industry Role: Join Date: Feb 2003 Location: NJ Posts: 13,332	W3 Total Cache can do a lot. I have one of the biggest adult sites using WordPress CMS. ICQ and I can help you out. __________________ ISeekGirls.com since 2005

10-08-2012, 04:22 PM	#4
wehateporn Promoting Debate on GFY Industry Role: Join Date: Apr 2007 Posts: 27,173	I have tried other Caches before, but this one seems too good to be true, even with the "Expire a cached query after" set on just 60 minutes. If it seems to good to be true, it probably is...I'll keep you updated __________________ Sexy Girls Teasing

10-08-2012, 04:33 PM	#5
TheSenator Too lazy to set a custom title Industry Role: Join Date: Feb 2003 Location: NJ Posts: 13,332	W3 has database caching .. r u using both at the same time? __________________ ISeekGirls.com since 2005

10-08-2012, 06:16 PM	#11
TheSenator Too lazy to set a custom title Industry Role: Join Date: Feb 2003 Location: NJ Posts: 13,332	30 days Pageviews: 3,541,217 I have APC(Alternative PHP Cache) installed with Database and Object cache turned on. I have the database and object cache expiring every 30 minutes. __________________ ISeekGirls.com since 2005

10-08-2012, 05:06 PM	#8
OneBallJohn Confirmed User Join Date: May 2002 Location: Inside Jimbo's head. Posts: 262	I've got a pretty heavy WP install that I've recently had some cache issues with. I think I'll install these two plugin you're recommending and see if things change for the better. Any things I should look out for when installing or configuring these two? Thanks for the thread.

10-08-2012, 06:56 PM	#12
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	looks like db cache reloaded uses a flat file cache, instead of a db or memory cache? __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

10-09-2012, 08:14 AM	#15
TheSenator Too lazy to set a custom title Industry Role: Join Date: Feb 2003 Location: NJ Posts: 13,332	Why do you have all your links opening up a new page? __________________ ISeekGirls.com since 2005

10-09-2012, 08:24 AM	#17
TheSenator Too lazy to set a custom title Industry Role: Join Date: Feb 2003 Location: NJ Posts: 13,332	You should also use redirection/cloak links to your affiliates. __________________ ISeekGirls.com since 2005 Last edited by TheSenator; 10-09-2012 at 08:28 AM..