5 ms·

Might be trickier to do this if the foreign key is across a shard or if the db record for the comment wasn't structured like this. One situation could be becaus

Might be trickier to do this if the foreign key is across a shard or if the db record for the comment wasn't structured like this. One situation could be because they store the threaded comments with the thread key in each record and also the parent comment key. This would be useful to pull down all the comments associated with a thread in one db query but also allow you to have the nested comments.

smiler 16y ago
37signals don't use sharding. They use one database server with enough RAM to load the db into memory
- jules 16y ago
  One database server for the whole of basecamp? Edit: I found this: > With that in mind, we went looking for an option to host the Basecamp database, which is becoming a monster. As of this writing, the database is 325GB and handles several thousand queries per second at peak times. 325GB RAM?! But now they have multiple servers. Read more: http://37signals.com/svn/posts/2479-nuts-bolts-database-servers http://37signals.com/svn/posts/2479-nuts-bolts-database-serv...
  - die_sekte 16y ago
    HP sells servers with up to 64 cores and 2 TB of memory. Considering the car that DHH just bought himself, they should be able to buy/lease several of them.
    - jules 16y ago
      Are these x86 servers? Or do you mean a single chip with 64 cores?
      - die_sekte 16y ago
        This thing: http://h10010.www1.hp.com/wwpc/us/en/sm/WF04a/15351-15351-3328412-241644-4222584 http://h10010.www1.hp.com/wwpc/us/en/sm/WF04a/15351-15351-33...
      - whatusername 16y ago
        http://www-03.ibm.com/systems/x/hardware/enterprise/x3850x5/features.html http://www-03.ibm.com/systems/x/hardware/enterprise/x3850x5/...
  - aaronblohowiak 16y ago
    You can get servers that can house 512GB or 1TB of RAM from HP/Sun/Dell. Scaling out your app servers and scaling up your DB is common in systems that don't need to be truly "web scale".
- die_sekte 16y ago
  They do that for everything but Basecamp[1]. I wonder what they use for Basecamp. [1] Second paragraph: http://37signals.com/svn/posts/2479-nuts-bolts-database-servers http://37signals.com/svn/posts/2479-nuts-bolts-database-serv...

smiler 16y ago

37signals don't use sharding. They use one database server with enough RAM to load the db into memory

jules 16y ago
One database server for the whole of basecamp? Edit: I found this: > With that in mind, we went looking for an option to host the Basecamp database, which is becoming a monster. As of this writing, the database is 325GB and handles several thousand queries per second at peak times. 325GB RAM?! But now they have multiple servers. Read more: http://37signals.com/svn/posts/2479-nuts-bolts-database-servers http://37signals.com/svn/posts/2479-nuts-bolts-database-serv...
- die_sekte 16y ago
  HP sells servers with up to 64 cores and 2 TB of memory. Considering the car that DHH just bought himself, they should be able to buy/lease several of them.
  - jules 16y ago
    Are these x86 servers? Or do you mean a single chip with 64 cores?
    - die_sekte 16y ago
      This thing: http://h10010.www1.hp.com/wwpc/us/en/sm/WF04a/15351-15351-3328412-241644-4222584 http://h10010.www1.hp.com/wwpc/us/en/sm/WF04a/15351-15351-33...
    - whatusername 16y ago
      http://www-03.ibm.com/systems/x/hardware/enterprise/x3850x5/features.html http://www-03.ibm.com/systems/x/hardware/enterprise/x3850x5/...
- aaronblohowiak 16y ago
  You can get servers that can house 512GB or 1TB of RAM from HP/Sun/Dell. Scaling out your app servers and scaling up your DB is common in systems that don't need to be truly "web scale".
die_sekte 16y ago
They do that for everything but Basecamp[1]. I wonder what they use for Basecamp. [1] Second paragraph: http://37signals.com/svn/posts/2479-nuts-bolts-database-servers http://37signals.com/svn/posts/2479-nuts-bolts-database-serv...