Menu

Category «Techie stuff»

Invalid UPCs culled and soft 404s fixed

Recently UPCZilla saw a major drop in traffic from Google. We quickly realised it was very likely due to the large number of soft 404s the Googlebot was finding, as well as excessive 500 errors due to some unoptimised database queries causing MySQL to hang when traffic was heavy. The soft 404s, it turned out, …

Solution for slow fulltext searches

This won’t interest most visitors to this site, but I had to post it somewhere as it will help someone out there, so it’s filed under Techie stuff. A bout of heavy Google crawling of the site forced me to look at some of our slow database queries, which could be overlooked when we had …