I wrote bsuite_speedcache to reduce the number of database queries I was executing per page load. By implementing it on some of the content in my sidebar, I dropped 35 queries for each cache hit. That might not seem like much, but it should average about 525 queries per minute that that my host server won’t need to process.
Now that I’m looking seriously at optimizing my queries, I’ve also cut the monthly archives links from the sidebar. The SELECT DISTINCT query it relies on hits MySQL hard. It wouldn’t be so bad if the get_archives function could be set to return the results (and my attempts at output buffering seemed to conflict with something else within WP), but it can’t and without being able to feed the results into the cache it has to be re-queried with every page load.
Between removing the archives links and bsuite_speedcache, I’ve gone from 136 to 99 queries for the front page and my story pages went from 65 to 28.
Where is it?
I’m going to ask my pal Zach (who knows a lot more about MySQL optimization than I do) to take a look at it with an eye toward making sure I’m not missing any easy optimization opportunities (and that I’m not causing trouble in one area I’ve got a question about).
With that done, and after I add some code to create the DB table and such, I’ll try to release it sometime this week.
tags: bsuite_speedcache, bsuite, cache, cache hit, codex, database, database caching, database optimization, database performance, database queries, mysql, mysql caching, mysql optimization, mysql performance, mysql queries, wordpress, wordpress optimization, wordpress performance, wordpress performance optimization, wordpress plugin
Related:
Posted October 3, 2005 by Casey
Categories: Technology. Tags: bsuite, bsuite_speedcache, cache, cache hit, codex, database, database caching, database optimization, database performance, database queries, mysql, mysql caching, mysql optimization, mysql performance, mysql queries, wordpress, wordpress optimization, wordpress performance, wordpress performance optimization, wordpress plugin.
4 Comments
Comments RSS
TrackBack Identifier URI
Sorry, the comment form is closed at this time.
User contributed tags for this post:
sex com (4292) - WWW 89 COM (2830) - 89 com (1679) - 89.com (488) - www com 89 (443) - www 89 com video (378) - www.89.com (347) - worldsex com (335) - ro 89 (333) - ro 89 com (323) - Www Worldsex Com (310) - www ro 89 com (235) - WWW 89 TV (217) - www 89 (199) - www.sexs.com (161) - worldsex.com (154) - www.com.89 (146) - www.ro.89.com (132) - www.worldsex.com (127) - sexs.com (126) - www.ro 89.com (124) - ro.89.com (116) - www 89 com my (112) - pink visual.com (97) - WWW SEX 89 COM (96) - http://www Pink World com/ (96) - www 89sex com (96) - www worldsex com my (93) - http://www.PINK WORLD.com/ (92) - WWW PINK VISUAL COM (92) - www 89 m (89) - sexs com (86) - pink visual com (86) - 89sex (85) - ro 89*com (85) - 89 com videos (75) - www 89 com (73) - www 89 sex com (71) - 89 sex com (70) - www.89sex.com (69) - WWW SEX COM (66) - ro 89.com (65) - www.worldsex.com.my (64) - WWW SEXS COM (61) - 89 com video (57) - WWW PINK WORLD COM (57) - world sexs (56) - WWW PINK COM (56) - www 89 tv com (52) - www.89.tv (51) - ww.89.com (50) - 89 WWW COM (50) - www.sex.89 (49) - 89 sexs (49) - www.89.m (48) - www.sex.com.my (47) - www.sex world.com (46) - sex 89 com (46) - WWW 89 SEX (46) - WWW PINK WORLDSEX com (46) - WWW COM SEX (45) - www 89 com tv (45) - RO.89COM (44) - ww 89 com (43) - www ro 89com (43) - WWW 89 COM MOVIES (42) - www.ro.89 (41) - www.89,com (39) - www.pink visual.com (39) - buffering sex (38) - Sex 89 (37) - 89sex.com (37) - 89sex com (36) - www.89 com (35) - WWW,89,COM (35) - www sex 89 (34) - www.89 (33) - F (33) - www.world.com (31) - word sexs (31) - WWW.89.SEX.COM (30) - www.world sexs.com (30) - 89.www.com (30) - www.89.com.my (30) - 89 (30) - WWW 89 SEXS COM (30) - sexs 89 (29) - 89 com my (29) - com 89 (28) - sex com tv (28) - pink world com (27) - WWW 89 COM SEX (27) - WWW PINK WORLD SEX COM (27) - www.pink world.com (26) - www ro 98 com (26) - www.pinkworldsex.com (26) - www.com.pink.world. (25) - 89,com (24) - www.com.89. (24) - 89 tv (24) - www.pink sex.com (24) - www.ro 98.com (24) - www.ro.98.com (24) - buffering sex videos (23) - 89com (23) - www 89/com (23) - 89.sex.com (23) - queries (22) - 89sex tv (21) - com.89 (21) - pink world.com (21) - www.89.sex (21) - worldsex (21) - w ww 89 com (21) - sex videos without buffering (21) - www,com,89 (21) - ro.89 (21) - http://www.pink world.com (20) - www.ro.89com (20) - ro 89 sex (20) - www ro 89 (20) - www.ro.89.com. (20) - www com 4 (19) - www.com.sex (18) - www.89 sex.com (18) - www.89 world.com (18) - ro.98.com (18) - www 89.com (17) - www.sex 89.com (17) - sexs video (17) - WWW COM WORLD SEX (17) - www 89 muvi (17) - or.89.com (17) - www.69.com. (16) - WWW PINK SEX COM (16) - sex 89 tv (16) - OR 89 com (16) - http//www 89 com (16) - sexs tv (15) - sex (15) - http//www.89.com (15) - 89sex video (15) - WWW 123 SEX COM (15) - sex buffering (15) - www world com (15) - www.pinksex.com (15) - www.com.89/ (15) - 89 sex (14) - www.com 89 (14) - world sex com (14) -
bsuite updated
Please post comments on the most recent release.
[...] 与bsuite_speedcache结åˆä¸€ä½“。 [...]
[...] Integrates bsuite_speedcache [...]
[...] 与bsuite_speedcache结åˆä¸€ä½“。 [...]