« Blog Research is online! | Main | Top Feedburner feeds »
Top 100 Feedburner sites on my Blog List
By maurizio | September 11, 2007
If you are new here, you may want to subscribe to my RSS feed. Feel free to leave comments and questions too.Thanks for visiting!
My beta version of the “unnamed” blog search/directory is going on very slowly. One of the thing that stopped me on these days are the Databases. Plural. I am using two distinct databases, as every search engine do. They probably use more than two, actually, but the design involves at least two Database objects. The first one is the Database for the spider/crawler and where all the calculation and grouping of stuff is done; the second one is the db used to show results on the site.
The problems I had with those two database is related on how to move datas from one to the other. I think I need to improve my SQL skills. When you are dealing with small databases, even if you don’t optimize your queries, you still get some results in a decent time. If you have a big Db, you must optimize queries. I’m slowly getting into it, but I surely need to test incremental backup too, otherwise I have to transfer the whole db every time and that’s not good.
Anyway I’d like to show you another test page, which is not linked on the main site.
The Top 100 Feedburner sites. The page doesn’t have any description at all. It’s just a table with sites and numbers. The first thing you’ll notice is that the first results have the same number of Circulation hits. The reasons are simple:
- Some sites are repeated twice (ie. with and without www)
- Some sites are using an old trick to show someone else’s stats.
From these two points you can see two things: the sites repeated twice are losing a lot of SERP points: instead of simply add a .htaccess to redirect traffic from site.com to www.site.com, they prefer to have two sites. Or, at least, they write links for both sites and my crawler saw two sites. I’ll probably solve this kind of problem sooner or later (probably waay later).
The second issue shows two dumb things. The first one is my fault. I’m reading the image instead of reading the hiperlink.I’m solving it right now, but it will take some days to solve it. The second dumb thing is what those webmasters are doing. They just fool their readers and that’s bad. The dumbest thing is that they aimed at the number one instead of just getting the chicklet of someone in the middle of the Rankings..
Topics: Content Creation, Programming |
Read other related posts:
September 11th, 2007 at 8:44 am
I like it! You should add it to the main page and write something around it.
First you need to remove those spammers.
September 11th, 2007 at 8:45 am
Why don’t you put it on your site instead of Clickys list which is now useless?
September 11th, 2007 at 8:56 am
I wonder if those webmasters even know they have two separate sites with and without the http://www.
September 11th, 2007 at 9:03 am
Thanks Milo.
Nick, I’ll probably do it.
Paula: No idea. You could send them an email if you wish. Due to the high feed readers they have, I hoped they know a bit of SEO.