The WordPress team has taken up the issue of performance optimization pretty seriously, and I look forward to the fruits of their efforts, but I’m also casting a critical eye on my own code. Thanks to caching and a hugely optimized query architecture, Scriblio is now performing better than ever, and I’m now looking at [...]
Posted January 23, 2008 by Casey Bisson
Categories: Technology. Tags: fixed, mysql, optimization, query, query optimization, wordpress. Be the first one.
I got itchy about magic quotes the other day because it’s the cause (through a fairly long cascade of errors) of some performance problems and runaways I’ve been seeing lately (pictured above).
But I deserve most of the blame for allowing a query like this to run at all:
SELECT type, data, count(*) AS hits
FROM wpopac_WPopac_bibs_atsk
WHERE data [...]
Posted August 23, 2006 by Casey Bisson
Categories: Libraries & Networked Information, Technology. Tags: bug, bugs, mysql, patch, performance, queries, query, query failures, wpopac. Be the first one.