You are reading a single comment by @Velocio and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Velocio
It's an interesting question, and the answer would be that it couldn't get too big to be impractical.
There are only a few search fields (username, IP address, email) and all could be hashed into single column PK tables that are partitioned by hash over multiple nodes.
So even without a map-reduce solution you could scale a SQL database up to billions of records providing you can afford enough nodes. Thankfully on that note an ISP is donating the machines for this, and to be honest 1.7 million entries is a small database... some of the LFGSS tables are way larger (did I ever tell the story of how the LFGSS backup passed 40GB last month and required me to upgrade servers on Christmas Eve?... LFGSS is roughly 6m rows of data in 180 database tables.).