Using one DB query per node in a tree is expensive, and if your tree is large, will horribly slow the site. The answer is to take a little more time on inserts and reap the efficiency rewards in selects. I’ve been using this technique for a while but I just mislaid my “rebuild tree” [...]
Entries Tagged as 'php'
August 11th, 2009 13 Comments
I just knocked this keyword density calculator together for my own use - there are plenty online that take a URL but I wanted one to automatically show the keyword density for offline documents - in other words I wanted to paste in the entire document, not just the URL.
Here’s the keyword density checker source [...]
April 27th, 2009 32 Comments
I was doing some SEO for an excellent site on Friday. Their on-page was excellent, and they had some desirable backlinks. One problem they did have though was duplicate content on their location-specific “doorway” pages - pages designed to rank for “Blue Widgets Ely”, “Blue Widgets Cambridge” etc
I proposed they at least “spun” the body [...]
March 29th, 2009 1 Comment
Just did a new video on downloading and installing WAMP
For some reason the “voice” audio codec I used only works on MySpace. The other video sites are silent.
WAMPserver is a hugely powerful and very easy-to-use package that allows you to run a complete server on your local computer, running the Apache webserver, MySQL [...]
How To Scale Your Web Technology For Product Launch - Lessons Learned From The Butterfly Marketing 2.0 Launch
March 25th, 2009 4 Comments
When the order link for the Butterfly Marketing 2.0 launch was emailed to Mike Filsaime’s “Early Bird” list yesterday, the BFM servers crashed pretty spectacularly. Ustream chatrooms were packed with unhappy punters jabbing the refresh button like woodpeckers - fearful they might miss the opportunity to be one of the first 5000 to grab what was undeniably [...]
January 6th, 2009 1 Comment
New Year = new direction…
After many years of almost seamless employment, I’m now available for freelance / consultancy work again.
I offer nearly 10 years professional PHP / MySQL development experience and, crucially, the ability to speak about highly technical matters to highly non-technical people - in a language they understand.
My commercial awareness sets me apart from the vast [...]