Current time: 04-26-2019, 07:43 PM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help and advice greatly appreciated.
11-16-2011, 03:55 AM
Post: #1
Help and advice greatly appreciated.
Hi to everyone here, really hope for some advice here as ive been literally teraing my hair apart for the past few days searching for a solution. Undecided

I've a wordpress site and recently changed webhost with litespeed servers shared-hosting, that i thought will certainly speed up my website.

What really puzzled me and frustrate me is everytime i test my inner webpages, it really takes more than 30 seconds to load and sometimes even time-out.

However when i retest it, the loading time becomes much shorter.

Ex http://www.webpagetest.org/result/111115_YF_26GC6/
(test taken with quick cache and wp-minify)

Ive tried the following wordpress cache plugins, like w3 total cache and quick cache, wp-minify.

w3 total cache gave me a very good yslow and pagespeed ranking, after i implemented it but the server load is horrendous, hitting from 50% upwards when i start to load my inner page. I enabled only page-cache and browser cache. The 1st time taken to load my inner webpage is >15 seconds.

Quick cache is simple enough for a non-techie like myself, and while it gave me a similar pagespeed rating as w3 total cache, i noticed the loading time is terribly long.

Any advice on how i should optimize my webpages, when loading for the first time?

P.s- im planning to implement cloudflare soon, but thought i would solve this first.

Thanks in advance for your time and help
Find all posts by this user
Quote this message in a reply
11-16-2011, 11:50 PM
Post: #2
RE: Help and advice greatly appreciated.
You have a serious back-end performance problem. The first visit is painfully slow because nothing is cached and that is showing the actual native performance of the application. The retests are a lot faster because the queries are going to be in the database memory cache (since they were just run recently).

If you go to the page and view the source, W3TC will display some debug information at the bottom of the page that can help:

Code:
<!-- W3 Total Cache: Minify debug info:
Engine:             disk: basic
Theme:              da177
Template:           single
Replaced CSS files:
1. wp-content/themes/topblog/style.css
2. http://www.wide-angle-macro-lens.com/wp-content/plugins/slickr-flickr/lightbox-slideshow/lightbox.css?ver=3.2.1
3. http://www.wide-angle-macro-lens.com/wp-content/plugins/slickr-flickr/slickr-flickr.css?ver=3.2.1
4. http://www.wide-angle-macro-lens.com/wp-content/plugins/wp-single-post-navigation/css/single-post-navigation.css?ver=1.1
5. wp-content/plugins/kk-star-ratings/css/kk-ratings.css
6. wp-content/plugins/jquery-vertical-accordion-menu/skins/black.css
-->
<!-- Performance optimized by W3 Total Cache. Learn more: http://www.w3-edge.com/wordpress-plugins/
Page Caching using disk: enhanced
Database Caching 41/172 queries in 1.384 seconds using disk: basic
Object Caching 1913/1991 objects using disk: basic
Served from: www.wide-angle-macro-lens.com @ 2011-11-16 21:45:31 -->

You can enable a lot more debug information in the plugin settings which can give you better timings and tell you what the database queries are that are taking a long time.

Ultimately, it's probably going to be an issue with the performance of the shared hosting provider (both on the web side and, more likely, their database performance). Shared hosting is notorious for exceptionally slow MySQL.
Visit this user's website Find all posts by this user
Quote this message in a reply
11-17-2011, 04:02 PM (This post was last modified: 11-17-2011 04:06 PM by mylemonhead.)
Post: #3
RE: Help and advice greatly appreciated.
Hi Preenam, thanks for your time. Ive added more debug info and the numbers are confusing me big time Huh Where do i look for info to find which db queries are the culprits.

Code:
<!-- W3 Total Cache: Db cache debug info:

Engine:             disk: basic

Total queries:      139

Cached queries:     112

Total query time:   0.9348

SQL info:

    # | Time (s) |    Caching (Reject reason)     |   Status   | Data size (b) | Query

    1 |   0.0006 |  disabled (Query is rejected)  | not cached |             0 | SHOW TABLES LIKE 'wp_dynamic_widgets'

    2 |   0.0008 |            enabled             | not cached |         10498 | SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_name = 'nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews' AND wp_posts.post_type = 'post'  ORDER BY wp_posts.post_date DESC

    3 |   0.0001 |            enabled             |   cached   |           503 | SELECT `post_parent` FROM wp_posts WHERE ID = 12807 LIMIT 1

    4 |   0.0009 |            enabled             | not cached |           789 | SELECT url FROM wp_cloakPig_cloaks WHERE cloak='nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews' OR cloak='/nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews' OR cloak='nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews/' OR cloak='/nikon-24-70mm-f2-8g-ed-af-s-nikkor-wide-angle-zoom-lens-reviews/'

    5 |   0.0002 |            enabled             |   cached   |          7147 | SELECT * FROM wp_posts WHERE ID = 12807 LIMIT 1

    6 |   0.0002 |            enabled             |   cached   |         10761 | SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date ASC LIMIT 0, 1

    7 |   0.0035 |            enabled             | not cached |          6395 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (2590) ORDER BY t.name ASC

    8 |   0.0009 |  disabled (Query is rejected)  | not cached |             0 | DELETE FROM wp_t09_sb_jobs WHERE done=1

    9 |   0.0001 |            enabled             |   cached   |           513 | SELECT MAX(id) FROM wp_t09_sb_log

   10 |   0.0001 |  disabled (Query is rejected)  | not cached |             0 | DELETE FROM wp_t09_sb_log WHERE id<15785

   11 |   0.0002 |            enabled             |   cached   |         19202 | SELECT field,`data` FROM wp_t09_sb WHERE pageid=0

   12 |   0.0003 |  disabled (Query is rejected)  | not cached |             0 | UPDATE wp_t09_sb SET `data`='1' WHERE  pageid=0 AND field='nonce'

   13 |   0.0002 |            enabled             |   cached   |          3589 | SELECT pageid FROM wp_t09_sb WHERE field='post_random' AND data='1' GROUP BY pageid

   14 |   0.0001 |            enabled             |   cached   |          1741 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=10

   15 |   0.0001 |            enabled             |   cached   |          1665 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=12

   16 |   0.0001 |            enabled             |   cached   |          1664 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=14

   17 |   0.0001 |            enabled             |   cached   |          1659 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=16

   18 |   0.0001 |            enabled             |   cached   |          1734 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=18

   19 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=20

   20 |   0.0001 |            enabled             |   cached   |          1681 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=22

   21 |   0.0001 |            enabled             |   cached   |          1683 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=24

   22 |   0.0001 |            enabled             |   cached   |          1668 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=36

   23 |   0.0001 |            enabled             |   cached   |          1667 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=40

   24 |   0.0001 |            enabled             |   cached   |          1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=46

   25 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=48

   26 |   0.0001 |            enabled             |   cached   |          1665 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=62

   27 |   0.0001 |            enabled             |   cached   |          1663 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=64

   28 |   0.0001 |            enabled             |   cached   |          1668 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=66

   29 |   0.0001 |            enabled             |   cached   |          1668 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=68

   30 |   0.0001 |            enabled             |   cached   |          1667 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=70

   31 |   0.0001 |            enabled             |   cached   |          1667 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=72

   32 |   0.0001 |            enabled             |   cached   |          1669 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=76

   33 |   0.0001 |            enabled             |   cached   |          1747 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=78

   34 |   0.0001 |            enabled             |   cached   |          1740 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=80

   35 |   0.0001 |            enabled             |   cached   |          1750 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=82

   36 |   0.0001 |            enabled             |   cached   |          1750 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=84

   37 |   0.0001 |            enabled             |   cached   |          1748 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=86

   38 |   0.0001 |            enabled             |   cached   |          1748 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=88

   39 |   0.0001 |            enabled             |   cached   |          1752 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=90

   40 |   0.0001 |            enabled             |   cached   |          1683 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=92

   41 |   0.0001 |            enabled             |   cached   |          1690 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=94

   42 |   0.0001 |            enabled             |   cached   |          1662 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=112

   43 |   0.0001 |            enabled             |   cached   |          1660 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=114

   44 |   0.0001 |            enabled             |   cached   |          1662 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=116

   45 |   0.0001 |            enabled             |   cached   |          1661 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=118

   46 |   0.0001 |            enabled             |   cached   |          1662 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=120

   47 |   0.0001 |            enabled             |   cached   |          1657 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=122

   48 |   0.0001 |            enabled             |   cached   |          1659 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=124

   49 |   0.0001 |            enabled             |   cached   |          1666 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=140

   50 |   0.0001 |            enabled             |   cached   |          1666 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=142

   51 |   0.0001 |            enabled             |   cached   |          1665 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=144

   52 |   0.0001 |            enabled             |   cached   |          1664 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=146

   53 |   0.0001 |            enabled             |   cached   |          1666 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=148

   54 |   0.0001 |            enabled             |   cached   |          1663 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=150

   55 |   0.0001 |            enabled             |   cached   |          1660 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=152

   56 |   0.0001 |            enabled             |   cached   |          1729 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=164

   57 |   0.0001 |            enabled             |   cached   |          1730 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=166

   58 |   0.0001 |            enabled             |   cached   |          1734 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=168

   59 |   0.0001 |            enabled             |   cached   |          1734 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=170

   60 |   0.0001 |            enabled             |   cached   |          1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=172

   61 |   0.0001 |            enabled             |   cached   |          1733 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=174

   62 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=176

   63 |   0.0001 |            enabled             |   cached   |          1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=178

   64 |   0.0001 |            enabled             |   cached   |          1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=180

   65 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=182

   66 |   0.0001 |            enabled             |   cached   |          1817 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=184

   67 |   0.0001 |            enabled             |   cached   |          1824 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=186

   68 |   0.0001 |            enabled             |   cached   |          1827 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=188

   69 |   0.0001 |            enabled             |   cached   |          1733 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=190

   70 |   0.0001 |            enabled             |   cached   |          1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=192

   71 |   0.0001 |            enabled             |   cached   |          1729 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=194

   72 |   0.0001 |            enabled             |   cached   |          1725 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=196

   73 |   0.0001 |            enabled             |   cached   |          1727 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=198

   74 |   0.0001 |            enabled             |   cached   |          1728 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=200

   75 |   0.0001 |            enabled             |   cached   |          1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=202

   76 |   0.0001 |            enabled             |   cached   |          1735 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=204

   77 |   0.0001 |            enabled             |   cached   |          1732 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=206

   78 |   0.0001 |            enabled             |   cached   |          1808 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=210

   79 |   0.0001 |            enabled             |   cached   |          1736 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=214

   80 |   0.0001 |            enabled             |   cached   |          1266 | SELECT id,string,accountid FROM wp_t09_sb_jobs WHERE done=0 LIMIT 0,1

   81 |   0.0002 |  disabled (Query is rejected)  | not cached |             0 | UPDATE wp_t09_sb_jobs SET done=1 WHERE id=17176

   82 |   0.0001 |            enabled             |   cached   |          1683 | SELECT `field`,`data` FROM wp_t09_sb WHERE pageid=92

   83 |   0.0001 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

   84 |   0.0001 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

   85 |   0.0001 |            enabled             |   cached   |          1384 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&amp;lcpt=0&amp;lcpf=0'

   86 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

   87 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

   88 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

   89 |   0.1353 |            enabled             | not cached |          1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A38Z&summary=0&truncate=5000&v=2&sig=k%2FPBUDRhB8vnP5dYASu7jTEu2Y4bQCSA69YVbEBm7HY%3D'

   90 |   0.0007 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A38Z&summary=0&truncate=5000&v=2&sig=k%2FPBUDRhB8vnP5dYASu7jTEu2Y4bQCSA69YVbEBm7HY%3D','/hiddendeals/ju0W','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

   91 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

   92 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

   93 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

   94 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

   95 |   0.1634 |            enabled             | not cached |          1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A39Z&summary=0&truncate=5000&v=2&sig=rJg7CubgRKpXE0c8LtZcDQ1QTaNGKSGl9%2F2oRt356Qk%3D'

   96 |   0.0007 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A39Z&summary=0&truncate=5000&v=2&sig=rJg7CubgRKpXE0c8LtZcDQ1QTaNGKSGl9%2F2oRt356Qk%3D','/hiddendeals/vdkQ','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

   97 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

   98 |   0.0001 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

   99 |   0.0002 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

  100 |   0.0001 |            enabled             |   cached   |          1384 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&amp;lcpt=0&amp;lcpf=0'

  101 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

  102 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

  103 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

  104 |   0.1583 |            enabled             | not cached |          1336 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=aC5qSrxvcx8WZfD6P%2Fe%2B%2FUJbfVBfQ3WrvrvA1o45t90%3D'

  105 |   0.0004 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=aC5qSrxvcx8WZfD6P%2Fe%2B%2FUJbfVBfQ3WrvrvA1o45t90%3D','/hiddendeals/5KmS','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

  106 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0000501QH%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0000501Q​H'

  107 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

  108 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

  109 |   0.0001 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

  110 |   0.2249 |            enabled             | not cached |          1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=wgopq97z0SWQpAANpIq6cFTtWjRw9aEDEuHIk%2B0p9hY%3D'

  111 |   0.0005 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=wgopq97z0SWQpAANpIq6cFTtWjRw9aEDEuHIk%2B0p9hY%3D','/hiddendeals/q0Xk','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

  112 |   0.0002 |            enabled             |   cached   |          1499 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Sigma-800mm-Ultra-Telephoto-Cameras/dp/B0009JKH00%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB0009JKH0​0'

  113 |   0.0003 |  disabled (Query is rejected)  | not cached |             0 | INSERT INTO wp_t09_sb_log(url,msg,type) VALUES('http://delicious.com/Minigrovy','Posting to delicious.com/Minigrovy','1')

  114 |   0.0005 |            enabled             | not cached |          1386 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&lcpt=0&lcpf=0'

  115 |   0.0021 |            enabled             | not cached |          9696 | SELECT p.* FROM wp_posts AS p  WHERE p.post_date < '2011-11-02 08:31:55' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date DESC LIMIT 1

  116 |   0.0001 |            enabled             |   cached   |           503 | SELECT `post_parent` FROM wp_posts WHERE ID = 12807 LIMIT 1

  117 |   0.0027 |            enabled             | not cached |          8082 | SELECT p.* FROM wp_posts AS p  WHERE p.post_date > '2011-11-02 08:31:55' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date ASC LIMIT 1

  118 |   0.0001 |            enabled             |   cached   |           503 | SELECT `post_parent` FROM wp_posts WHERE ID = 12807 LIMIT 1

  119 |   0.0002 |            enabled             |   cached   |           885 | SELECT DISTINCT widget_id FROM wp_dynamic_widgets
                  WHERE  maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')

  120 |   0.0002 |            enabled             |   cached   |          1746 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'text-25'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  121 |   0.0002 |            enabled             |   cached   |          2015 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'text-23'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  122 |   0.0002 |            enabled             |   cached   |          2015 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'text-26'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  123 |   0.0002 |            enabled             |   cached   |          1746 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'text-15'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  124 |   0.0002 |            enabled             |   cached   |          1750 | SELECT widget_id, maintype, name, value FROM wp_dynamic_widgets
                  WHERE widget_id LIKE 'execphp-3'
                    AND (maintype LIKE 'single%' OR maintype IN ('date', 'role', 'browser', 'tpl', 'wpml', 'qt')) ORDER BY maintype, name

  125 |   0.0002 |            enabled             |   cached   |          3143 | SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('2824') ORDER BY tr.object_id ASC

  126 |    0.001 |            enabled             |   cached   |         48124 | SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (10733,10734,10736,10737,10739,10740,10742,10743,10745,10746,10747,10748,10753,1​0754,10755,10756,10758,10759,10760,10761,10763,10764,10765,10766,10767,10768,107​69,10770,10771,10772,10773,10775,12033,12034,12035,12052,12053,12054,12055,12056​,12794,12808,13510,13511,13512,13918,15246,15270) AND wp_posts.post_type = 'nav_menu_item' AND (wp_posts.post_status = 'publish')  ORDER BY menu_order ASC

  127 |   0.0011 |            enabled             | not cached |           884 | SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (2590) ORDER BY t.name ASC

  128 |   0.0002 |            enabled             |   cached   |          5689 | SELECT content FROM wp_wpr_templates WHERE type = 'amazon'

  129 |   0.0002 |            enabled             |   cached   |          1386 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.linkconnector.com/traffic_affiliate.php?lc=054882037831004157&lcpt=0&lcpf=0'

  130 |   0.0005 |            enabled             | not cached |          1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3​C'

  131 |   0.0002 |            enabled             |   cached   |          1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3​C'

  132 |   0.0002 |            enabled             |   cached   |          1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3​C'

  133 |   0.2199 |            enabled             | not cached |          1334 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B000VDCT3C&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A42Z&summary=0&truncate=5000&v=2&sig=vI9p%2BbFW7LAEIEzXlWcX50PK%2BKCYFDedoOcgykuDceo%3D'

  134 |   0.0004 |  disabled (Query is rejected)  | not cached |             0 | INSERT IGNORE INTO `wp_cloakPig_cloaks` (`url`,`cloak`,`a`,`hits`,`type`) VALUES ('http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B000VDCT3C&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A42Z&summary=0&truncate=5000&v=2&sig=vI9p%2BbFW7LAEIEzXlWcX50PK%2BKCYFDedoOcgykuDceo%3D','/hiddendeals/27oN','<a rel=\"external nofollow\" href=\"CLOAK_FORMAT\">','0','Auto')

  135 |   0.0001 |            enabled             |   cached   |          1495 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/Nikon-24-70mm-2-8G-Nikkor-Angle/dp/B000VDCT3C%3FSubscriptionId%3DAKIAICA22YDS2RFDD3EA%26tag%3Dwideanglemacr-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3DB000VDCT3​C'

  136 |   0.0007 |            enabled             | not cached |          4900 | SELECT * FROM wp_comments  WHERE comment_approved = '1' AND comment_post_ID = 2590 ORDER BY comment_date_gmt ASC

  137 |   0.0001 |            enabled             |   cached   |           632 | SELECT term_taxonomy_id
                    FROM wp_term_taxonomy
                    WHERE taxonomy = 'category'
                    AND term_id IN (1)

  138 |   0.0005 |  disabled (Query is rejected)  | not cached |             0 | SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( wp_term_relationships.term_taxonomy_id IN (1) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 20

  139 |   0.0002 |  disabled (Query is rejected)  | not cached |             0 | SELECT FOUND_ROWS()

-->
Find all posts by this user
Quote this message in a reply
11-17-2011, 11:33 PM
Post: #4
RE: Help and advice greatly appreciated.
Look through the Time (s) column and see which queries are taking a long time. The ones that jump out in this case are:

Code:
89 |   0.1353 |            enabled             | not cached |          1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A38Z&summary=0&truncate=5000&v=2&sig=k%2FPBUDRhB8vnP5dYASu7jTEu2Y4bQCSA69YVbEBm7HY%3D'
  95 |   0.1634 |            enabled             | not cached |          1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A39Z&summary=0&truncate=5000&v=2&sig=rJg7CubgRKpXE0c8LtZcDQ1QTaNGKSGl9%2F2oRt356Qk%3D'
  104 |   0.1583 |            enabled             | not cached |          1336 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0000501QH&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=aC5qSrxvcx8WZfD6P%2Fe%2B%2FUJbfVBfQ3WrvrvA1o45t90%3D'
  110 |   0.2249 |            enabled             | not cached |          1332 | SELECT cloak,a,id FROM wp_cloakPig_cloaks WHERE url='http://www.amazon.com/reviews/iframe?akid=AKIAICA22YDS2RFDD3EA&alinkCode=xm2&asin=B0009JKH00&atag=wideanglemacr-20&exp=2011-11-18T05%3A56%3A40Z&summary=0&truncate=5000&v=2&sig=wgopq97z0SWQpAANpIq6cFTtWjRw9aEDEuHIk%2B0p9hY%3D'

I don't know much about the CloakPig plugin but it looks like it is probably responsible for most of your performance issues. You can add a database index to the url column of the wp_cloakPig_cloaks table if one doesn't already exist or if the plugin isn't critical to your site you can also disable it.

Since it is a commercial product you could also reach out to the developer and see if they have any updates that can address performance issues.
Visit this user's website Find all posts by this user
Quote this message in a reply
11-18-2011, 12:01 AM
Post: #5
RE: Help and advice greatly appreciated.
ur right pmeenam, ive installed wordpress debug and it seems this plugin is the main culprit. Thanks again for your time and patience.

You gave me a direction, now im better aware of the situation and nt as clueless. Blush
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)