794 karma · joined March 7, 2007
also previously @ angellist, hotornot, etc.
http://zohrob.com https://twitter.com/dzohrob
email: username at gmail
http://fretwar.com/static/data/round/1/media/xzibitonics_C.m...
That same Alexa data you quote has POF at 168 in the US and 466 worldwide, with 21+ average pageviews/visit (Compete has them closer to 30). According to that same data, Flickr has ~9 PVs/visit, and CNN has ~3.5.
It's not inconceivable that with a few differences in the data between Hitwise and Alexa, you could come up with POF in the top 20. It just shows you how meaningless pageviews are as a metric of success or engagement.
1) "across the room" -- stand 10 feet away from your machine and see if you can tell what you're supposed to do
2) "don't make me think" -- i'm sure anyone who has ever used a website has to think about this one.
if you actually want people to sign up, make it easier, not harder. save your creativity for your content.
when i clicked through this morning, there was a user-submitted, reasonably well-written rant against the uncov guys, along with some back-and-forth in the comments. it's gone now.
156.4M monthly US pageviews 224.1M monthly global pageviews
http://www.alexa.com/data/details/traffic_details/cuil.com?s...
"When designing UX think about what your mom would use, not what Louis Gray would use"
That's probably a good rule. That's not saying build something a geek wouldn't use.
http://www.w3counter.com/globalstats.php?date=2008-05-31
Not that it's the best source of data, but.
[1] http://en.wikipedia.org/wiki/Usage_share_of_web_browsers
Mysql-proxy (http://forge.mysql.com/wiki/MySQL_Proxy) looks promising, but it's still in an alpha state. You could try writing a proxy script in Lua -- there's already some master /slave stuff done in this area.
Mysql 5.1 supports partitioning, but not really in the way that you and I mean.
The problem is that sharding breaks some fundamental SQL axioms -- for example, doing SELECTs no longer returns all rows (depending on how the table is partitioned).
Almost everyone I know who does this rolls their own layer. As subwindow mentioned, if you're using Rails, you have to futz with establish_connection due to ActiveRecord's assumptions about one DB connection per class. It's possible -- we've done it -- but it requires lots of connections to the DB and it can be messy. If you're on Rails, it might be easier to scale vertically first before going horizontal.
Replication doesn't need to change in this context -- the Mysql documentation should be all you need to get started.