Help and advice greatly appreciated.

Web Performance Discuss Test Results
1

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. :-/

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

2

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:

<!-- 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.

3

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&lcpt=0&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%3DB0000501QH’

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%3DB0000501QH’

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%3DB0000501QH’

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%3DB0000501QH’

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%3DB0009JKH00’

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%3DB0009JKH00’

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%3DB0009JKH00’

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%3DB0009JKH00’

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&lcpt=0&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%3DB0000501QH’

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%3DB0000501QH’

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%3DB0000501QH’

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%3DB0000501QH’

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%3DB0009JKH00’

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%3DB0009JKH00’

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%3DB0009JKH00’

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%3DB0009JKH00’

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,10754,10755,10756,10758,10759,10760,10761,10763,10764,10765,10766,10767,10768,10769,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%3DB000VDCT3C’

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%3DB000VDCT3C’

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%3DB000VDCT3C’

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%3DB000VDCT3C’

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()

–>[/code]

4

Look through the Time (s) column and see which queries are taking a long time. The ones that jump out in this case are:

   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.

5

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:

6

If no effect is observed after 6 weeks on 400 mg daily, a response is not likely and consideration should be given to alternate treatment options.
Poor Metabolizers of CYP2C9 Substrates: Patients who are known or suspected to be poor CYP2C9 metabolizers based on genotype or previous history/experience with other CYP2C9 substrates such as warfarin, phenytoin should be administered celecoxib with caution.
Price Of Celebrex
Celebrex Side Effects
Celebrex 200 Mg
Celebrex Pain Relief
Cheap Celebrex
Celebrex Dosage
Order Celebrex
Buy Celebrex In Canada
This symptom complex typically occurs in asthmatic patients who experience rhinitis with or without nasal polyps, or who exhibit severe, potentially fatal bronchospasm after taking aspirin or other NSAIDs see Contraindications 4, Warnings and Precautions 5.
Celebrex Commercial
Other factors that increase the risk of GI bleeding in patients treated with NSAIDs include concomitant use of oral corticosteroids or anticoagulants, longer duration of NSAID therapy, smoking, use of alcohol, older age, and poor general health status.
Celebrex Uses
In controlled clinical trials of Celebrex, the incidence of borderline elevations greater than or equal to 1.
Celecoxib
Celebrex Online
Hepatic insufficiency: The daily recommended dose of Celebrex capsules in patients with moderate hepatic impairment ChildPugh Class B should be reduced by 50%.
The increases in both celecoxib dose groups versus placebotreated patients were mainly due to an increased incidence of myocardial infarction see Clinical Studies 14.
Cost Of Celebrex
Cheap Celebrex Online