MySQL Full-Text Search Is Broken!

...and has been for 8 years. I came across MySQL bug #2095 today: full-text search for words containing hyphens won't work Submitted: 11 Dec 2003 6:15 Hyphen '-' characters break literals at the moment. A search for something like "GATA-D22S690" finds all entries containing GATA and not the full hyphenated text. ~ Link MySQL disputes … Continue reading MySQL Full-Text Search Is Broken!

DIGG: 4000% PERFORMANCE INCREASE BY SORTING IN PHP RATHER THAN MYSQL

To scale at Digg they followed a set of practices very similar to those used at eBay. No joins, no foreign key constraints (to scale writes), primary key look-ups only, limited range queries, and joins were done in memory. When implementing the comment feature a 4,000 percent increase in performance was created by sorting in … Continue reading DIGG: 4000% PERFORMANCE INCREASE BY SORTING IN PHP RATHER THAN MYSQL

How To: Exclude Words Like “An, A, The” From Alphabetized MySQL ORDER

When ordering lists of names or titles it's sometimes desirable to exclude articles or other words from the order clause (eg. you want "The Burning Hell" to show up before "Great Lake Swimmers" in a list ordered by name). Early on in my career I must have assumed it was not possible and never bothered … Continue reading How To: Exclude Words Like “An, A, The” From Alphabetized MySQL ORDER