Speeding Up Wordpress - Database Cache

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wehateporn
    Promoting Debate on GFY
    • Apr 2007
    • 27176

    #1

    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
  • TheSenator
    Too lazy to set a custom title
    • Feb 2003
    • 13340

    #2
    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

    Comment

    • wehateporn
      Promoting Debate on GFY
      • Apr 2007
      • 27176

      #3
      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

      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.

      Comment

      • wehateporn
        Promoting Debate on GFY
        • Apr 2007
        • 27176

        #4
        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

        Comment

        • TheSenator
          Too lazy to set a custom title
          • Feb 2003
          • 13340

          #5
          W3 has database caching .. r u using both at the same time?
          ISeekGirls.com since 2005

          Comment

          • wehateporn
            Promoting Debate on GFY
            • Apr 2007
            • 27176

            #6
            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

            Comment

            • wehateporn
              Promoting Debate on GFY
              • Apr 2007
              • 27176

              #7
              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."


              Last edited by wehateporn; 10-08-2012, 03:51 PM.

              Comment

              • OneBallJohn
                Confirmed User
                • May 2002
                • 262

                #8
                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.

                Comment

                • wehateporn
                  Promoting Debate on GFY
                  • Apr 2007
                  • 27176

                  #9
                  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

                  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.

                  Comment

                  • OneBallJohn
                    Confirmed User
                    • May 2002
                    • 262

                    #10
                    Sounds simple enough. Thanks again.

                    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

                    Comment

                    • TheSenator
                      Too lazy to set a custom title
                      • Feb 2003
                      • 13340

                      #11
                      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

                      Comment

                      • Brujah
                        Beer Money Baron
                        • Jan 2001
                        • 22157

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

                        Comment

                        • Nasty
                          Confirmed User
                          • Aug 2002
                          • 1575

                          #13
                          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

                          “Ours is a world of nuclear giants and ethical infants. We know more about war than we know about peace, more about killing than we know about living. If we continue to develop our technology without wisdom or prudence, our servant may prove to be our executioner.” ― Omar Bradley (1948)

                          Comment

                          • wehateporn
                            Promoting Debate on GFY
                            • Apr 2007
                            • 27176

                            #14
                            Thanks for sharing that

                            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.

                            Comment

                            • TheSenator
                              Too lazy to set a custom title
                              • Feb 2003
                              • 13340

                              #15
                              Why do you have all your links opening up a new page?
                              ISeekGirls.com since 2005

                              Comment

                              • wehateporn
                                Promoting Debate on GFY
                                • Apr 2007
                                • 27176

                                #16
                                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

                                Comment

                                • TheSenator
                                  Too lazy to set a custom title
                                  • Feb 2003
                                  • 13340

                                  #17
                                  You should also use redirection/cloak links to your affiliates.
                                  Last edited by TheSenator; 10-09-2012, 07:28 AM.
                                  ISeekGirls.com since 2005

                                  Comment

                                  • wehateporn
                                    Promoting Debate on GFY
                                    • Apr 2007
                                    • 27176

                                    #18
                                    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
                                    Last edited by wehateporn; 10-09-2012, 07:27 AM.

                                    Comment

                                    • TheSenator
                                      Too lazy to set a custom title
                                      • Feb 2003
                                      • 13340

                                      #19
                                      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.
                                      ISeekGirls.com since 2005

                                      Comment

                                      • wehateporn
                                        Promoting Debate on GFY
                                        • Apr 2007
                                        • 27176

                                        #20
                                        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?

                                        Comment

                                        • TheSenator
                                          Too lazy to set a custom title
                                          • Feb 2003
                                          • 13340

                                          #21
                                          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.
                                          ISeekGirls.com since 2005

                                          Comment

                                          • wehateporn
                                            Promoting Debate on GFY
                                            • Apr 2007
                                            • 27176

                                            #22
                                            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

                                            Comment

                                            Working...