I recently rebuilt the Cornwall24 website in the hope that upgrading from a 3 year old verwion of PostNuke to a new version of WordPress might stop the site taking down the server by overloading MySQL at least once a… Read More »Speeding up MySQL
The rebuild of the TransEurope Marinas website is complete and the site is now live at www.transeuropemarinas.com. Working along side designer Todd Barden from t2 Design the new site is a major upgrade from the existing static webiste. The site… Read More »TransEurope Marinas Webiste Goes Live
Here’s an SQL query that’ll return all the duplicate rows in your table. SELECT `id`, COUNT(*) as `dup` FROM `table_name` GROUP BY `id` HAVING `dup` > 1 ORDER BY `dup`
This article is just a quick look at how search engine optimisation has changed over the years and how the SEO “expert” and the search engines have played a game of “cat and mouse” over the years. It is only a brief look at some of the ways better search engine ranks could be achieved by SEO and how the search engine algorithms were updated in response.Read More »Brief History of SEO
The problem: What I wanted to do here was find a way of speeding up a query that was run on MySQL database on a different server. Also I’m a big fan of caching generally, especially when the data is… Read More »Caching remote MySQL queries with PHP
PostNuke was one of the first open source content management systems out there dating back to 2001. Based on PHPNuke it offered a framework for publishing content and user management. Over the years it did improve and provided inspiration for… Read More »PostNuke – The End