I have over 1000 posts here at MaisonBisson, but even so, the table with all those posts is under 3MB. Now I’ve got a project with 150,000 posts — yes, 150,000 posts! — and the table is about 500MB. An associated table, structured sort of like WP’s postsmeta, has over 1.5 million records and weighs [...]
Posted January 17, 2006 by Casey Bisson
Categories: Technology. Tags: big databases, database optimization, db, mysql, mysql optimization, mytop, optimization, server overload, server sizing. 2 Comments.
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 [...]
Posted October 3, 2005 by Casey Bisson
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.
