Monday, January 26, 2009
Tuesday, January 06, 2009
MySQL Performance Tip - Indexes and Wildcards
This one is kind of obvious once you think about it, but I had overlooked it in my code, so I figured maybe some other webmasters out there may have as well. I found this snippet explaining the tip I want to share from a site called websitedatabases.com:
MySQL also uses indexes for LIKE comparisons if the argument to LIKE is a constant string that doesn't start with a wildcard character. For example, the following SELECT statements use indexes:
SELECT * FROM tbl_name WHERE key_col LIKE 'Patrick%'; SELECT * FROM tbl_name WHERE key_col LIKE 'Pat%_ck%';
In the first statement, only rows with 'Patrick' <= key_col < 'Patricl' are considered. In the second statement, only rows with 'Pat' <= key_col < 'Pau' are considered.
The following SELECT statements will not use indexes:
SELECT * FROM tbl_name WHERE key_col LIKE '%Patrick%'; SELECT * FROM tbl_name WHERE key_col LIKE other_col;
Saturday, December 13, 2008
The NoFollow Debacle...
I've been researching whether or not to utilize the "nofollow" attribute on my user-generated links for about a week now.
Javascript function:function goLink(o){var u = o.innerHTML;document.location = u;return;}
Then I simply made a matching style class to have the link appear as a link:[div class="link" onClick="goLink(this);"]http://www.user-added-link.com[/div]
.link {color: blue;cursor: pointer;text-decoration: underline;}
Thursday, November 20, 2008
Simple Trick To Increase Your Pageviews & Revenues By 20%
A few weeks back I was reading a forum thread over at DigitalPoint about a webmaster who had added some handy navigation links to his pages that helped him browse through his content more easily. He was talking about how he had initially added the new navigation links to help him keep up with monitoring the content more easily. However after implementing his new links, he found the total pageviews he was getting on his site had jumped up. Users were finding his new links helpful as well.
Monday, October 27, 2008
Are You Losing Out On Links To Your Site?
This is a huge tip for webmasters out there who have not yet discovered the new 404 feature released in Google's Webmaster Tools.
Wednesday, September 10, 2008
How To Game Google SERPS
- writecomplaint.com
- upsetclient.com
- upsetshopper.com
- pleasedconsumer.com
- reviews-by-company.blogspot.com
- bankerreviews.com
- a380reviews.com
- anotherreview.com
- clientstory.com
- customer-story.com
- corpreviews.com
- financingreviews.com
- shopperstory.com
- healthrunner.com
- hithealth.com
The funny part is they actually start the link farm out from their own homepage… See their “Our Friends” section.
From there, each site links to a few other sites in the link farm. And so on and so on. I never reached the "end" of the link farm, so there could be more than 100 sites.
Interestingly they make no effort to conceal the fact that they are all pointing links back to the parent site, PissedConsumer.com. Every one of these blogs has the exact same format/template, and every one of them links back to the parent site using sub-domain links.
To make matters even more interesting, all of these sites in their link farm reside on the same IP address (69.72.137.86).
If I was able to find all this in about 15 minutes, how is it that Google cannot figure it out? Perhaps there may be a loophole in their algorithm regarding links using subdomains? From past threads I've read about how Google views subdomains as separate domains. This may be the trick being used to get around their spam filter.
Another tactic they are using evolves around Blogger domains. Here is just a small sample I found:
- home-design-review.blogspot.com
- internet-reports.blogspot.com
- appliancereports.blogspot.com
- travelreportsreviews.blogspot.com
- electronics-reports.blogspot.com
- carandtruckreport.blogspot.com
They are obviously doing something right, Quantcast claims they are pulling in 400,000+ visitors/month. And for the handful of queries we tested, they seemed to always land in the coveted top ten of serps:
- http://www.google.com/search?hl=en&q=expedia+complaints
- http://www.google.com/search?hl=en&q=lowes+complaints
- http://www.google.com/search?hl=en&q=office+depot+complaints
- http://www.google.com/search?hl=en&q=home+depot+complaints
If the site was being penalized for gaming serps, they shouldn't be showing in the top ten for every search we tried in their niche.
Seems like a problem when it is this easy to game the system.
Thursday, September 04, 2008
SEO ThinkTank Event Contest - San Diego

I just dropped by Shoemoney.com and found out Jeremy is having a contest for folks to submit entries stating how they could add value to this event by attending. The winner gets an all expense paid trip to the conference. Pretty cool.





