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.
I’m going out on a limb to say MySQL’s full-text indexing and searching features are underused. They appeared in MySQL 3.23.23 (most people are using 4.x, and 5 is in development), but it’s been news to most of the people I know.
Here’s the deal, the MATCH() function can search a full-text index for a string [...]
Posted September 6, 2005 by Casey Bisson
Categories: Technology. Tags: boolean search, boolean searches, boolean searching, database, db, docs, documentation, full text, full text index, full text search, full text searching, fulltext, fulltext search, keywords, match(), mysql, rank, relevance, relevance rank, relevance ranked, relevance ranking, search, search full text. 8 Comments.
