Daesan, > > 2. This one is a bit more practical issue. Let's say I'm building a > > public forum hosting service. (It is indeed something I have in > > mind.) At some point, my site hosts 10,000 forums, each having its > > own forum_id. Let's say each forum has average of 10,000 topics, > > each having its own topic_id. And each topic has average of 100 > > replies, each having its own reply_id. If I have to use a flat > > integer id space, there will be replies with id like #10,000,000,000. > > (10,000 * 10,000 * 100) Now, 32-bit unsigned integer can't handle it > > since its max value would 4,294,967,295. I could just use 64-bit > > unsigned integer, I guess, but it does take more spaces and what if > > my site becomes even more successful to the extent even 64-bit > > integer will max out?
You'd really run 10,000 forums out of one database with shared tables? The argument is for the sake of argument. If you're that successful, you wouldn't make that choice. _______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core
